Pivot table dimension

[stephenedberkg]

i want to show the top 1st rank salesman(only one salesman) in pivot table dimension

my dimension expression is below

=  Only(if( Aggr( rank( (sum({<Year= {$(=Max(Year))},MonthID={$(=Max(MonthID))},TransactionType = {'Inv'},Month,Year=,Quarter=>}$(vSalesBtn))

-

sum({<Year= {$(=Max(Year))},MonthID={$(=Max(MonthID))},TransactionType = {'Credit'},Month,Year=,Quarter=>}$(vSalesBtn)))),SalesMan)=1,SalesMan))

i want achieve like below image

[tresesco · Accepted solution]

May be like:

= Aggr(If( rank( (sum({<Year= {$(=Max(Year))},MonthID={$(=Max(MonthID))},TransactionType = {'Inv'},Month,Year=,Quarter=>}$(vSalesBtn))

-

sum({<Year= {$(=Max(Year))},MonthID={$(=Max(MonthID))},TransactionType = {'Credit'},Month,Year=,Quarter=>}$(vSalesBtn))))=1,SalesMan),SalesMan)

If this doesn't help, try to share your sample qvw.

[stephenedberkg]

tresesco‌

Thank you