I am having hard time to rank lowest average number as rank 1, currently it ranking highest average number as rank 1. My current formula see below,
rank([Total Average], [Store Number])
I want it like below picture. How should I do that? Any help will be really appreciate. Thank you
