Rank In Pivot table

Wed, 25 Nov 2020 16:16:04 GMT

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!!

Re: Rank In Pivot table

beck_bakytbek — Mon, 16 Jan 2017 12:36:29 GMT

Hi Singh,

look at this:

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

beck

topic Rank In Pivot table in QlikView

Rank In Pivot table

Re: Rank In Pivot table