How to calculate rank in Pivot table

[Kalyan2]

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

Kalyan

[Kalyan2 · Accepted solution]

I tried this and its working at both levels.

if(Dimensionality()=2 ,only({<Company = {'Company2'}>}aggr(rank(Sum(Sales)), Category, Country, Company)),
only({<Company = {'Company2'}>}aggr(rank(Sum(Sales)), Molecule, Country, Company)))