I created a pivot table in Qlikview that is using the same sum(value) and is sorted in descending order based on an expression (i.e. rank(sum(value))). I want to how to sort the inner part of the pivot table so that it is also in descending order because the values are spread throughout the first part of the dimension.
Example:
Dimension 3 across the top
Dimension 1 Dimension 2 Monday Tuesday Wednesday Sum total
Team 1 Analyst 5 6 7 18
Associate 1 2 3 6
VP 4 5 6 15
SVP 7 8 9 24
Total 63
Team 2 Analyst 4 5 7 16
Associate 1 2 3 6
VP 4 5 6 15
SVP 7 8 9 24
Total 61
Team 3 Analyst 1 2 7 10
Associate 1 2 3 6
VP 4 5 6 15
SVP 7 8 9 24
Total 55
Anyone know how to sort the total and the subtotal, please advise.
Why not use the same method for sorting the remaining columns but with different expression? You sorted 1st column by rank(sum(value))), sort the next column by anything else you wish.
Maybe a sample would help if I have not understood well.
I sorted both the total and subtotal by the same expression. The problem is dimension 2 (analyst, associate) shows up multiple times within the pivot so I can't just sort dimension 2 alone in descending order.
