Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
SkitzN27
Creator
Creator

Pivot Table Ordering

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.Annotation 2020-07-22 095553.png 
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?

3 Replies
Qlik1_User1
Specialist
Specialist

In Pivot table there is an option of sorting, use custom sort  --> "sorting by expression" and mention the sorting expression .

SkitzN27
Creator
Creator
Author

What would be that expression?
Perc(%) Increase is a calculated field here and the table consists of more than 30 states in total.

Qlik1_User1
Specialist
Specialist

try to use rank function here or firstsortedvalue.