This topic contains 0 replies, has 1 voice, and was last updated by 
-
Posts
-
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
)
The forum ‘Power Pivot’ is closed to new topics and replies.