Top 20 customer in a pivot table

[#1]

Hi,  I need to pick my top 20 customer in a pivot table and som the sales. The dimensions I want to use is Company, SalesPerson and Year. Thus I dont want to show the customer but still calculate per customer.

So in eack cell below the sales value for the com´pany, salesperson and year should be shown, the will be different customers calculated.in each cell.

Can it be done and if so how?

//K

Company	SalesPeron	Year	2012	2013	2014	2015
1	A
1	B
2	C
2	D
3	E
3	F
3	G

[Qrishna]

try

if(Aggr(rank(Sum({1}SalesQuantity)),[SalesPerson],Company,year)<=20,[SalesPerson])

[#3]

Hi Krishna,

No that does not work. I've tried several ways to solve this and

If(Aggr(Rank(Sum(SalesQuantity)), Company, SalesPerson, Year) <= 20, Sum(SalesQuantity))

If(Rank(Aggr(Sum({1}SalesQuantity), Company, CustomerNo, SalesPerson, Year)) <= 20, Sum(SalesQuantity))

Stil I need to have CustomerNo in the aggr function othervise I'll not aggegate over the customer.

/Klas

[Qrishna]

can you post the qvw with some sample data.?