Top n values according to the selected criteria in pivot table

[#1]

Hi All,

I am trying to get top n values say 20 for a selected criteria in a pivot table like Top 20 companies by spend in that specific region.

Can some one help me please?

Thanks.

[SunilChauhan]

Create an  like below

Load * inline

[

Columnname

top1

top2

top3

top4

.

.

.

]

and in chart _>properties->presentation->max Number shown

if(Columnname='top1',1,if(Columnname='top2',2,if(Columnname='top3',3)))

U can add more as per need.

Thanks

Sunil

[#3]

Expression:

aggr(if(rank(sum(sales)) <= vTopRanking,rank(sum(sales))),Year,Customer)

vTopRanking is a variable so you can get the top 10, 15, or any number you type in.

Year is the dimension and the pivot tables columns and Customer (also a dimension) is what I am aggr on.

hth,

Stephen