Home Forums Power Pivot Blank column on a PIVOTTABLE

This topic contains 0 replies, has 1 voice, and was last updated by  sjhc1177 1 week, 4 days ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #18159

    sjhc1177
    Participant
    • Started: 24
    • Replies: 25
    • Total: 49

    Hi, I have a measure that works on fining the top 25 MODELS sold this month. I then use the same measure but modified for OH and again for INTRANSIT.

    My issue is the column in the PIVOT TABLE isn’t wide enough to show the name, but I dont want to widen it as the other items above and below fit in the column.

    What I need is a blank column in the pivot table to allow more data from the left column to appear.

     

    This is my current measure.

    TOP 25 MODEL UNITS SOLD:=VAR RankingContext =
    VALUES (‘tblInvMaster'[BRAND – MODEL])
    VAR TopNumber = 25
    RETURN
    CALCULATE (
    [SALES UNITS SOLD],
    TOPN ( TopNumber, ALL( ‘tblInvMaster'[BRAND – MODEL]),[SALES UNITS SOLD] ),
    RankingContext
    )

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.