Sort total Coulmn

[#1]

Hello all,

     How to sort total column in pivot table ,as shown in image ,i need to sort the

Total column in descending order (Like 1411, 643, 381)?????

[whiteline]

Hi.

Go to the sorting tab, select CallSource dimension. Toggle override group sorting order. Then type the expression you want to be used for sorting.

[SunilChauhan]

chart properties-> sort ->select dimension Callsource(or groupname)-> expression ->[Total]

see the attched example

[#4]

thanks sunil,,,
but wherez attached sample ??

[whiteline]

Open a full theme view, the attachments are hidden when you look through inbox.

[stigchel]

Sorry, but you cannot reference the expression in the sort expression (try changing the sort order and you will see it does not change). Instead copy the complete calculation in the sort expression.

[SunilChauhan]

i am attaching again

[SunilChauhan]

We can use Expression name over that object .it will work. you may try this

[Gysbert_Wassenaar]

In the example below the expression used is count(Sales). The table is sorted by Product using the expression aggr(count(Sales),Product in descending order.

[stigchel]

Have you tried changing the sort order from ascending to descending in your example?