Rank for multiple years

[#1]

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.

[shiveshsingh]

Hi

you can refer below thread.

How to use rank function?

[sergio0592]

Maybe like this:

Sales :

Rank:

[vidyasagar159]

Hi,

Did you found the answer to this issue?

Thanks,

-Vidya

[jerryyang756]

Year and Product as Dimension

Expression:

If(Product='a' and (Year=2015 or Year=2016),

VRank(TOTAL Sum(Sales),0,1))