Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
try
if(Aggr(rank(Sum({1}SalesQuantity)),[SalesPerson],Company,year)<=20,[SalesPerson])
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
can you post the qvw with some sample data.?