One metric

The dimension members are ranked by one metric.

If you selected the Display Row Totals option, then the last row of the report shows totals for all the values in the metric column.

One metric and 80/20 columns

The first column displays a ranked list of the dimension members.

The Rank column displays the index number at which the members are ranked.

The % column shows the percentage that this member contributes to the total result.

The Cum. % column displays the percentage that this member, and all the members above it in rank, contribute to the total result.

The Cum. Rank column displays the percentage that this member, and all the members above it, represent within the total number of members in the focus dimension.

If you selected the Display Row Totals option in the Presentation section, then the last row of the report shows totals for all the values in the metric column. It also sums the % column to show the percentage that the ranked members contribute to the total.

Two metrics

The dimension members are ranked using the first metric. An additional column of numbers represents the ranking order of the dimension members for the second metric.

If you selected the Display Row Totals option, then the last row of the report shows totals for all the values in the first metric column and the second metric column.

Two metrics and 80/20 columns

The dimension members are ranked using the first metric.

An additional column of numbers represents the ranking order of the dimension members for the second metric.

The % column shows the percentage that this member contributes to the total metric.

The Cum. % column displays the percentage that this member, and all the members above it in rank, contribute to the total metric.

The Cum. Rank column displays the percentage that this member, and all the members above it, represent within the total number of members in the dimension.

If you select the Display Row Totals option, then the last row of the report shows totals for all the values in the metric columns. It also sums the % column to show the percentage that the ranked members contribute to the total.

Two time periods

The dimension members are ranked based on the highest to lowest value of the metric using the first time period. An additional column of numbers represents the ranking order of the dimension members for the second time period.

If you select the Display Row Totals option, then the last row of the report shows totals for all the values for each time period.

Two time periods and 80/20 columns

The dimension members are ranked based on the highest to lowest value of the metric using the first time period. An additional column of numbers represents the ranking order of the dimension members for the second time period.

The % column shows the percentage that this member contributes to the total time period.

The Cum. % column displays the percentage that this member, and all the members above it in rank, contribute to the total time period.

The Cum. Rank column displays the percentage that this member, and all the members above it, represent within the total number of members in the dimension.

If you select the Display Row Totals option, then the last row of the report shows totals for all the values in the time period columns. It also sums the % column to show the percentage that the ranked members contribute to the total.