Group by in Aggr() or chart expression

[MEBG93]

Hello everyone!

Silly question: is there a way to Group by a dimension in a aggr () function? I need to show only the top salesmans each by their highest sales. Eg: attached picture

[Femke]

Hi MEBG93

You can try to put a limitation in your chart (see picture) and choose for the top 3?

Kind regars

Femke V

[MEBG93]

Hi Femke! Yes i'm aware of that functionality, although that criteria comes independently from the overall performance. I just want to show the top sales by salesman. 

I tried doing if(rank(sum(sales), 3)=1, sum(sales)) but didn't grouped by salesman.

Thanks!

[Femke]

Did you try this: Sum(Aggr(max(Sales,Salesman)