See the following video to learn more about Ranks.
Ranking allows you to answer business questions such as:
- Which 3 regions generate the most revenue?
- Which are the bottom 10% of stores in terms of revenue generation?
- What is the group of the best-performing stores that generates a combined revenue of up to $10,000,000?
You can rank data in many ways to answer these kinds of business questions. You can:
- Rank a number of top and/or bottom records by dimension (for example Country) based on the sum of a related measure (for example Revenue).
- Rank the top and/or bottom records by the percentage of the total number of records by dimension, based on the value of a related measure as a percentage of the total value of the measure.
- Rank a number of top and/or bottom records by dimension based on the cumulative sum of a related measure.
- Rank a number top and/or bottom records by dimension based on the value of a related measure as a cumulative percentage of the total value of the measure.
Ranking and Data Order
You cannot rank an object whose values depend on the data order because the ranking changes the data order.
If the data order is changed, the object data is changed, and this results in a recalculation of the ranking. The result is a circular dependency between the ranking and the object that cannot be resolved.
If you create a rank on a measure whose values depend on the data order, for example a measure that uses the Previous function, the #RANK error code appears in all cells in the block.