Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I want to sort my pivot table on the basis of percentage increase for the different states from the month of May to June.
Considering the current table, I would like to show Alaska first (as the percentage increase for Alaska from May to June is highest i.e. 476.52%),
Second will be Arizona with 383.91% and lastly Alabama.
Can someone help me?
In Pivot table there is an option of sorting, use custom sort --> "sorting by expression" and mention the sorting expression .
What would be that expression?
Perc(%) Increase is a calculated field here and the table consists of more than 30 states in total.
try to use rank function here or firstsortedvalue.