Sorting As Per Partial Sums

[#1]

Dears,

Good day.

I am having a pivot table with partial sums (columns totals) on the right-side, and I would like to do the sorting of the table on base of those total amounts, is that possible??

Many thanks in advance.

Mauriccio

[brenner_martina]

Hi,

you can enter in the Tab Sort an expression like Sum(Sales) for all dimensions, ASC or DESC

[Oleg_Troyansky]

Hi,

sorting by expression in Pivot Tables is somewhat tricky... The sorting expression is evaluated for each individual Dimension, not for a combination of Dimensions.

For example if pivot table shows Sales by Customer and Product, and both Dimensions are sorted by sum(Sales), descending - the Customers will be sorted based on total Sales by Customer, and the Product will be sorted based on the total Sales by Product (not based on sales of this product for this particular customer). So, the most selling Product overall will always appear first, even if it happens to be #5 for a particular Customer.

just wanted to clarify this point...

[#4]

Dear Oleg,

Actually, it is a very good point, because I tried what Martina suggested (many thanks Martina), however It does not sort descending my customers as per total of sales, in fact, appears a big mess.

Any thoughts??

Mauriccio

[Oleg_Troyansky]

It's hard to guess what you specific problem might be, without seeing your application...

You can try and build a sorting espression using function AGGR() and forcing all the dimensions into the calculation