Sort pivot table on 2 dimensions

Anonymous — Thu, 27 Nov 2014 13:14:00 GMT

Okay this is most probably not true and must be easy but I cannot get it…

I have very simple table:

- Product

- Months

- Sales

I want to sort my table on the 2 dimensions

- The products – descending – top sales ones first – so descending based on Y value - sales

- The months – obviously – chronologically – in my case alphabetically or numerally

Thank you,

P.s. Okay I saw some people have seen this - so I if I make a Sort -> Expression ->Descending on the Customer Sum(Sales) it will work....

But in reality I am using different conditionally showed (with buttons) expressions so this most likely will not work for me as I will have different sorting expressions based on my current expression....

topic Sort pivot table on 2 dimensions in QlikView

Sort pivot table on 2 dimensions