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?
You can sort on a dimension based on an expression.
Sort --> (Pick dimension) --> Sort by Expression --> Enter Expression here --> Ascending or Descending
Retrieving data ...