how to get only one SalesPerson who has highest sales

[#1]

Hi all,

Im having the data with 3 dimensions Region ,SalesPerson, Sales

Each Region having 3 SalesPerson ,

I want max Sales in each region with only one Salesperson who having that max sales in that perticular region.

help me out

Thanks&Regards

AbdulRajak

[sunny_talwar · Accepted solution]

May be like this:

Dimension:

Region

SalesPerson

Expression:

If(Rank(Sum(Sales)) < 2, Sum(Sales))

[#3]

Yeah...

Its working,

Thanku,

But if Salespersons are n means????

[sunny_talwar]

Salespersons are n means? Not sure I understand this line of yours?