How to: Get Max Value for make invitation list

[panwipa2528]

I have raw data for prepare invitation list.
For Invitation list I need to select agent name who will take care member, so I will select Agent who member have max(sum(sale)).

If you confuse about what I am talking about please see photo as attach file.

[sunny_talwar]

Try using FirstSortedValue()

[panwipa2528]

Sale is not field in dimension how should I do?

[tresB]

Then how do you get sales value?

[kuba_michalik]

Either use Aggr in formula (see example) or preaggregate data in script with group by.

FirstSortedValue requires 1:1 relationship between sorted field and sort weight field, so you can't use it directly when your sort weight is a result of aggregation.

[sunny_talwar]

You can just do something like this

FirstSortedValue(ShopName, -Aggr(Sum(Sales), MemberID))