Regarding sort for Total

[sarfaraz_sheikh]

Dear all,

I am using three dimensional pivot table i want to sort the list Total wise for dimension which i want.

How i can achive the same ...little bit i am confused in that.

Qvw and screenshot  is also attached here for your refrence.

Sarfaraz

[tyagishaila]

which total wise sorting you need?

There are two totals 1 is column and another is Total of pivot table()

[sarfaraz_sheikh]

Hi Shaila,

I want column wise...

Sarfaraz

[avinashelite]

use the total expression in the sort tab expression this will do:

please find the attachment for the solution.

[sarfaraz_sheikh]

Dear Avinash,

I want the column wise total to be sorted ....that is my requirement.

Sarfaraz

[nigel987]

Hi, did you find a solution for this yet?