Sort issue

[knightwriter]

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?

[Chanty4u]

can u share sample qvw?

or screen sht hw it luks?

[marcus_sommer]

Have a look here: Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level)

- Marcus

[avinashelite · Accepted solution]

you could add a sorting expression in the sort tab...like

sum(TOTAL<Name, Sub Name>total )

[knightwriter]

Hi Avinash,

This partially works but ranks from lowest to highest, how do I flip it?

[knightwriter]

sorry, got it by changing to descending !