Rank For multiple Years

[prabhas277]

Hi Experts,

Please find the below xlsx file which contains the data for the 3 years.

now for that data i want rank for the multiple years like 2015,2016 for Specific  field a.

explanation::

If i click on  2015 ,2016 years  for product a then i want rank for both years..

how to get the rank for those years?

Thanks in advance

[swuehl]

Maybe use a table chart with dimensions year, product

Expression

=Sum(sales)

Rank in year

=Rank(Sum(sales))

Overall rank

=Rank(TOTAL Sum(sales))

[sunny_talwar]

This?