Hi there,
Is there a way to make a static rank, as opposed to a dynamic one? I want to create a ranking, and then add more dimensions. When I add more dimensions the ranking is ruined.
See the attached workbook with dummy data. I want to rank a Dimension by a sum of a measure, and then use that rank as static. If you see the second tab I would want the rank to look like (11111,222,333) etc.
Any help would be greatly appreciated.
Regards,
8 answers
