Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Try like below
Aggr(Rank(Sum({1}Sales)), Region, Country, Molecule)
Hi thanks for providing the solution
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 |