Showing max count in a table.

[sanpor1zd]

Hi guys,

i have a table with employee's name, and their sales transaction. 

im trying to show only employee with the most number of sales.

so in this case, i just want to show Alex with a count of 9 sales. 

may i know the way of doing this

thank you.

[tresesco · Accepted solution]

Dimension: Employee

Exp : Count({<Employee={"=Count(Sales)= Max(total Aggr(Count(Sales), Employee))"}>} Sales)

I am not sure if I have over-complicated the expression.

[sanpor1zd]

Hi Tresesco,

there is an error in the expression youve given. 

[tresesco]

Corrected. (in red).

[sanpor1zd]

thank you !

Cheers