Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have 3 years (2015,2016,2017) data. Each year is having 3 fields like a,b,c like below table.
Year | Sales | Product |
---|---|---|
2015 | 20 | a |
2015 | 30 | b |
2015 | 15 | c |
2016 | 40 | a |
2016 | 50 | b |
2016 | 55 | c |
2017 | 70 | a |
2017 | 40 | b |
2017 | 23 | c |
I want to get rank for 2015 and 2016 for product a .
How to write the expression for this.
Maybe like this:
Sales :
Rank:
Hi,
Did you found the answer to this issue?
Thanks,
-Vidya
Year and Product as Dimension
Expression:
If(Product='a' and (Year=2015 or Year=2016),
VRank(TOTAL Sum(Sales),0,1))