Filtering the top 5 sales from a pivot table

[cafcptg2011]

Hi,

I need to filter the customers (from a top 5 sales pivot table) that has sales in 2011 and 2012 (and exclude the others customers). To understand better i show you a picture with my problem. Also, i attached qvw with pivot table.

Can anyone one help me please?

Thanks in advance,

Cafc

[Gysbert_Wassenaar · Accepted solution]

Try:

= if(aggr(rank(SUM (sales ),0),id)<=5

          and aggr(sum({$<y={'2011'}>} sales),id) > 0

          and  aggr(sum({$<y={'2012'}>} sales),id) > 0, id)

[cafcptg2011]

Hi, it works!!

Thank you very much!