Calculation Wizard: Rank calculation

The Calculation Type page accepts input for the following items for a rank calculation:

Rank

Select the dimension used to calculate rank.

Select the hierarchy to be ranked in the specified dimension.

Within

Select one of the following items to specify the area within which the ranking is to be performed:

Total. Represents the sum total of the level that is associated with the current member.
Parent. Represents the parent of the current member.
Level. Specifies the level value.

Based on

Select a measure to serve as the basis of the ranking.

Order

Select the sequence of the ranking: (1) Highest to Lowest; (2) Lowest to Highest.

This type of calculation applies to measures only.

Formula Description

This formula is used to return the numeric rank value of each dimension member based on the value of the specified measure.

An example of this calculation is:

Rank of TV Sales where DVD is 150, TV is 100, and Radio is 50, would be 2.