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
Put exrp2 in all dimension for sorting as Descending and try
or share some sample app
Thanks P M,
I tried the same but didn't get success.
I cant share the data.
Hi,
sort order is calculated once per graph (Total Expression).
So maybe exp2 -> 1st in Col2 /A and 2nd in Col2/B.
Regards,
Antonio
Hi Antonio,
I didn't get your point "Col2 /A and 2nd in Col2/B."
Anyone knows how i can sort in pivot table?
share some scramble data it will might help.
Hi,
I am getting the pivot table second expression sorted.
You have only sorted the first dimension by expression.
But, Put same sorting by expression to second dimension as well
Regards,
Pankaj
Hi Narender,
Pivot table work on group wise sorting. So, you need to sort one by one by dimensions.
Thanks
Ravi Balar
I did the same but no success.
Thanks