Sorting dimensions in pivot table

[Anonymous]

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

[VishalWaghole]

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

[Anonymous]

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?

[Anonymous · Accepted solution]

I found the solution plus an example .qvf file in the comment of luismadriz‌ in this discussion Pivot Table Sorting - Qlik sense

Thanks Luis!