Top 15 Sales Rep 2013 VS 2014 how to assign the exact rank

[Geostidet]

Top 15 Sales Rep 2013 VS 2014 how to assign the sales Rep rank when he did make it to the top 15 instead of 16-17.

[vinieme12]

maybe you are ranking on the wrong measure or an ID field that has changed for 2013 and 2014

[Geostidet]

Hi @vinieme12   I am ranking and taking just the top 15  so a sales Rep can be in the top 15 in 2023 but not in 2014. so what I want is instead of having 15-17  I want the rank for  2014.

[Chanty4u]

Try something like this 

=RANK(SUM({<Year={2013}>} SalesAmount), 4) +

 RANK(SUM({<Year={2014}>} SalesAmount), 4)