Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
Hi,
PFA an example.
Use Rank() function
First expression
IF(RANK(Sum(Sales1))<=3,Sum(Sales1))
Second
IF(RANK(Sum(Sales2))<=3,Sum(Sales2))
Hi,
PFA an example.
Use Rank() function
First expression
IF(RANK(Sum(Sales1))<=3,Sum(Sales1))
Second
IF(RANK(Sum(Sales2))<=3,Sum(Sales2))