Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am uisng a pivot table and I am using 3 dimensions and one Sum total in the expression.
Name, Sub Name, Month & Total. I have month as horizontal.
I am looking to list the highest total Name and then Sub name under that, at the moment, it only lists the sub name by highest total. I have selected Y-value on the Name dimension and still no luck.
Any suggestions?
you could add a sorting expression in the sort tab...like
sum(TOTAL<Name, Sub Name>total )
can u share sample qvw?
or screen sht hw it luks?
Have a look here: Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level)
- Marcus
you could add a sorting expression in the sort tab...like
sum(TOTAL<Name, Sub Name>total )
Hi Avinash,
This partially works but ranks from lowest to highest, how do I flip it?
sorry, got it by changing to descending !