Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I did the same as Pankaj suggested but no success.
Thanks
Can you please share a sample app?
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