Top 3 Values in Pivot Table

[soha1902]

Hi All,

First of all I want to say sorry to posting this question again which is already asked by several times.

But I am not able to get the top 3 values in pivot table for one dimension and two dimension. I am attaching one sample app please some one help me regarding this.

Thanks in advance..

[SergeyMak · Accepted solution]

Hi,

PFA an example.

Use Rank() function

First expression

IF(RANK(Sum(Sales1))<=3,Sum(Sales1))

Second

IF(RANK(Sum(Sales2))<=3,Sum(Sales2))