Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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