I have a pivot table with 2 dimensions (Customer Name and internal company) and 2 measures (2019 and 2020 sales).
How can I allow the user to sort the pivot table by measure? Intuitively, they should be able to click the column header to sort like on straight tables.
Thank you for this solution. It’s not as clean as I would like it to be. This is a necessary function and should be a standard function of the pivot table chart.
If anyone from Qlik reads this, please make this a standard feature of the pivot table chart. I’m sure many others would also appreciate it.
