I am currently working with pivot table in qlikview and the order is location>route>delivery>product
and I want it sorted in descending order of the metric all of dimension
eg: 1st location in desc order of metric ,if user expands single location it should display route of selected location in desc order and so on with delivery and product
I used metric expression to sort it but didn't work
