Name having max value in table using Set Analysis

[300sss300]

I am trying the following set analysis to get the name of branch with highest sale but its not working

Max({<Year={'2019'},Month={'Feb'},Day={'28'}>} B_N)

It only gives numerical value if we use

Max({<Year={'2019'},Month={'Feb'},Day={'28'}>} Sales)

Date Fields:

Date    B_N     Sales

[Sergey_Shuklin · Accepted solution]

Hello!

There is no any clue if B_N contains uniq values or not, so you can use any of this methods:

For uniq values

For non-uniq values

In the attached file values are different beacuse I've reloaded it.