Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to sort on a pivot table expression field?
On the sort tab in the properties of your pivot table. Click on the dimension (usually the one on top) you want to sort, then click sort by expression and put in the expression you want to sort by.
On the sort tab in the properties of your pivot table. Click on the dimension (usually the one on top) you want to sort, then click sort by expression and put in the expression you want to sort by.
Thanks - if I could read!
what if i want to sort by the last column of my expressions