Skip to Content

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.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply