Sort on expression in pivot table

[#1]

Hi All,

I have a pivot table and i would like to sort on the expression (which in my case is a sum). How can i do this since sorting is done based on dimension?

[#2 · Accepted solution]

ggoyal_123-

You can sort on a dimension based on an expression.

Under properties:

Sort --> (Pick dimension) --> Sort by Expression --> Enter Expression here --> Ascending or Descending