Skip to main content
Meet the 2024 Qlik Luminaries and Partner Ambassadors! READ ON!
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

How to calculate rank in Pivot table

Hi All,

I need to calculate rank of company2 at Molecule , Category and country level in Pivot table.

I have only Molecule , Category and country in pivot table

only({<Company = {'Company2'}>}aggr(rank(Sum(Sales)), Molecule, Category, Country, Company)) this is working for Category level but not working as expected at molecule level.

how to get rank of Company2 sales at Molecule level also.

Please help me thanks in advance


Labels (2)
0 Replies