To Show Top Sales Person for each Region

[nithin2012]

Hi , 

I need to show the top sales person for each region in the dashboard and not using load script. 

Sample Data : - 

Expected Result : - 

Mathew	Central	3109
Susan	East	3102
James	West	1284

Sales is a measure which calculates the sum . 

Could you please help me to get the required result in the dashboard. 

[Taoufiq_Zarra · Accepted solution]

Hi,

many possibilities

One solution

Dimension: Rep,Region

Measure:

=if(Rep=FirstSortedValue(total <Region> Rep,-aggr(sum(Sales),Rep,Region)),sum(Sales))

output :

[eliran]

Hi,

One easy solution is using the following code

max(aggr(sum(Sales),Region,Rep))

Eliran.

[nithin2012]

HI Eliran , 

I tried this initially but it did not work out for me . I still get all the results