I am trying the following set analysis to get the name of branch with highest sale but its not working
It only gives numerical value if we use
Date B_N Sales
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.
View solution in original post