How show Top Ranked Salesperson in a column?

[#1]

I'm using a straight table with customer dimension on the left side.

I would like to write an expression that shows the Salesperson with the highest sales to that customer.

Ideally, I'd like to create an expression which shows the name, then another column/expression to show the percent of total customer sales that Salesperson is responsible for.

Thanks in advance!

[montubhardwaj]

Hi,

when you put Customer as Dimension and Sales as expression, then the total sales will be divided based on Customer. So add another Dimension say SPName(sales person name). Then in the expression,write somethingn like Max( AGGR(Sales,SPName)). This will give the Highest sales of a salesperson to a Customer.

Regards,

Dinesh Sharma

[Anonymous]

Hi,

Go to chart properties-->Dimension Limits-->click on (which value are displayed using the first expression)-->

show only--> set your value as largest.

Thanks,

[Anonymous]

Hi

try this

Aggr(Rank(Sum(customersales)),Salesperson)<=2 ....for top  2

Aggr(Rank(Sum(customersales)),Salesperson)<=3 .... for top 3

or simply

Aggr(Rank(Sum(customersales)),Salesperson)           ..... for all ranks

[Anonymous]

HI,

In straight table use the following code in dimension level, expression contains total sales.

=if(aggr(rank(sum(Sales)),Country,Salesman)=1,Salesman)

Regards

Pavan N