Ranking Number

[GraceGao]

Hi Experts

How can add ranking number in the pivot table as below?  I have set fixed top 10 product in the pivot table and want to add one ranking number in front of product. Please help. Thanks.

[MayilVahanan]

HI @GraceGao 

Try like below

Dim:

=Aggr(If(Rank(Sum(Sales))<=10, Rank(Sum(Sales))), Product)