Hi I want to display the average of the 3rd and 4th rank values per branch.
The ranking is done per period for the branch.
My current formula works fine if I select a specific branch, but I want to display the average per branch without selecting a branch.
I.e. the last column needs to display 10.5 for branch ‘03‘ and 7.5 for branch ‘02’. See example.
You could use something like this:
and change the number of the rank depending on which rank do you want to show (maybe using ColumnNo()?)
Some other similar questions you may find useful:
View solution in original post