Max of sales help

[mahitham]

Hi Experts,

Can any one please help me on below requirement.

In the below Pivot Table I have to show only Department wise Max sales employee details only instead of all the  other employees.

Current Table:

Expected Table:

I have used the below expression for Sales. please help me to modify the below expression for max of sales

Sum(${<MonthDiff={0}>}Sales)

Thanks in advance

[Channa]

FirstSortedValue( Employee, -Aggr(sum({<MonthDiff={0}>} Sal),Department, Employee))

try