Sort in Pivot table

[narender123]

Hi Team,

I have a pivot table with 2 columns and 2 expression.

Like:

Col1    Col2     exp1    exp2

I want the exp2 in descending order.

When the pivot table not expended then the exp2 shows the amount in descending order. But when i expend the Pivot table then amount not show in descending order.

I set the expression in sort but didnt get the result as i want.

Please let me know how to show the amount in descending order when pivot table is fully expended.

Thanks,

Narender

[narender123]

I did the same as Pankaj suggested but no success.

Thanks

[balar025]

Can you please share a sample app?

[Anonymous]

Hi Narender,

How are you??

when no cloumns are expanded chart dimnesionality is 1 and when you expand second dimensionality

increases and from 1 it become 2.

in your sort tab where you are writing  expresion sum({<Flag={8}>} TAX_AMOUNT )

write  if( dimensionality()=2, Rank(sum({<Flag={8}>} TAX_AMOUNT ) )  and check expression check box

and keep selecting drop down  as descending for both of your expression .

It may work.

Thanks

Anant Dubey

9718365394