I have a rankx measure which when used on it's own ranks the Grand total as 1, order desc. ,
but when I add the Total Unfits measure even though the grand total is still ranked 1 so is the highest value in the collumn,
I have this hard coded and controlled by a slicer to give various top N values. I've attached the workbook with two pivots one for the slicer,]and the other
showing the two Ranks of one?
I would just like some guidance on what's happening, and also if I just had the ranking, is there way in power pivot to 'turn off' including the grand total?
I've tried isfilered but not got it right.
Richard.
Bookmarks