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

[prma7799]

Put exrp2 in all dimension for sorting as Descending and try

or share some sample app

[narender123]

Thanks P M,

I tried the same but didn't get success.

I cant share the data.

[antoniotiman]

Hi,

sort order is calculated once per graph (Total Expression).

So maybe exp2   -> 1st in Col2 /A  and 2nd in Col2/B.

Regards,

Antonio

[narender123]

Hi Antonio,

I didn't get your point "Col2 /A  and 2nd in Col2/B."

[narender123]

Anyone knows how i can sort in pivot table?

[prma7799]

share some scramble data it will might help.

[passionate]

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

[balar025]

Hi Narender,

Pivot table work on group wise sorting. So, you need to sort one by one by dimensions.

Thanks

Ravi Balar

[narender123]

I did the same but no success.

Thanks