Regarding the Rank

[Sunilkumar3]

Hi I have Region, country and Molecule. in the Data. I want to show Region, country and Molecule Sales and their Rank. in a Table.  Below are the Sample Data.

Region,    Country,    Molecule,    Sales
R1,    C1,    M1,    100
R1,    C1,    M1,    20
R1,    C1,    M1,    30
R1,    C2,    M1,    200
R1,    C3,    M1,    300
R1,    C3,    M1,    30
R1,    C2,    M1,    20
R1,    C2    M2,    50
R1,    C1,    M2,    100

R1,    C2,    M2,    150
]; 

If  I Select any Region, country and Molecule then Show its Actual Rank Based on the Sales 

[MayilVahanan]

Hi

Try like below

Aggr(Rank(Sum({1}Sales)), Region, Country, Molecule)

[Sunilkumar3]

Hi thanks for providing the solution

[Sunilkumar3]

Hi Team,

I have Created a Adhoc Report and I have multiple dimensions and Measure. Below are the Example.

If I Select Jan-2023 then Result should be Below. Means I want the result in Single Row . Can any one guide how write the expression. for that

Month_year	CY Sales	LY sale
Jan-23	10	15