I would like to tell the users the importance of Reset Dimension Parameter in Rank Function.
Recently, I was asked to create a simple rank report that shows the Rank in ascending order.
The rank should be based on the sales value & partners, but specific to the country. for e.g., if there are 10 partners in a country there sales should be ranked independently from 1-10. Other partners in a different country should be given separate ranks.
For this scenario, The Rank function has a reset dimension parameter, that helps us to get to this very easily.
It has below syntax,
=Rank([Measure];Top/Bottom;[Dimension])
example:
=Rank([Total_Sales];Top;([Country Name]))
Top – refers that the rank will applied in ascending order.
[Country Name] – this is reset dimension.
Hope this example helps to understand the importance of Reset Dimension Parameter in Rank Function.
Kindly share your feedback on this.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
11 | |
7 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |