Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have a pivot table with the following fields:
fieldnames between brackets []
Rows: Months [Month], Customer as [Bill-to-Customer]
Column: Category [Product Category]
Measure: Sales, which is sum({<Year={'2017'}>}[Nett Amount new EUR])
I do have the top 10 customers per category per month, but now I want to sort these customers based on the sales (descending).
So, the end result should be a pivot where the top 10 customers are shown per category and per month, sorted with the biggest customer on top.
How should I make this sortation in the set analysis?
Mike
I found the solution plus an example .qvf file in the comment of luismadriz in this discussion Pivot Table Sorting - Qlik sense
Thanks Luis!
Reger below document.
Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level)
Hope this will be helpful for you.
Thanks,
Vishal
First of all, thanks for your reply vishalwaghole!
I love the idea, but I can't get it working in Qlik Sense.
Should this only be possible in View or also in Sense?
I found the solution plus an example .qvf file in the comment of luismadriz in this discussion Pivot Table Sorting - Qlik sense
Thanks Luis!