Rank In Pivot table

[#1]

Hi Guys,

I have a pivot with dates on the top, as groupers, & below them you have paid amounts.
Something like :

I have figured out the way to show only top 5 dim based on the Paid Amount, but this top 5 list is on the Total Paid amount(Paid for 2012+paid for 2013....).
What I want is to have the top 5 dim on the Paid amounts of a single year(say 2015).
So the pivot is as displayed but the top 5 dim are based on the top 5 paid amounts for 2015 & not the total paid amounts.
Formula used for the top 5 is:

=aggr(if(rank(sum(paidamount))<6,dim, 'Other'),Field1,dim)

                    //dim is ranked on the paidamount & aggregated by Field1

Please advise.

Thanks in advance!!

[beck_bakytbek]

Hi Singh,

look at this:

https://www.youtube.com/watch?v=KCPKNYWmb5g

beck