How to sort by expression?

[Anonymous]

Hi,

I have a pivot table and will like to sort by the expression, for example my expression is a sum of records, so I will like to sort from higher to lower.

The sort by Y-value is not working.

Any idea?

[vishsaggi · Accepted solution]

Check Expression and write

Sum(YourfieldName)

Then change that to Descending. LIke: