Lookup in aggr

[#1]

I'm having a hard time filtering out a result in a subdataset. Right about now I'm working with a gaming company and would need to filter out the game with the best score in a report. Consider this example:

PROBLEM

QUESTION

How do we write the formula for column "best game"?

Best Regards

[sunny_talwar · Accepted solution]

May be like this:

FirstSortedValue(game, -Aggr(Sum(Score), game, player))

UPDATE: May be you need date in there as well:

FirstSortedValue(game, -Aggr(Sum(Score), game, player, date))

[marcus_sommer]

Have you tried: rank(sum(score)) within such a table-chart?

- Marcus

[#4]

I was trying around with both aggr and FirstSorted but manage to fail. Thanks a lot guys, it was as simple as that