You can show values as a percentage or share of a crosstab total to quickly compare the contribution of an item to the whole.
If the crosstab contains a user-defined arithmetic calculation, such as addition, subtraction, multiplication, or division, Analysis Studio computes the arithmetic calculation first, then applies the % of base calculation when you show values as a percentage. This is also true with exponentiation and rollup calculations.
If the crosstab contains a user-defined percent calculation, such as percent, % growth, percent of base, or accumulated percent, there is no change when you show values as a percentage. This is also true with statistical calculations, such as mean or standard deviation, and ranking calculations, such as rank or quartile.
For more information about item-based calculations, see Item-based Calculations.
Right-click the measures corner of the crosstab.
Click Show Values As.
Choose the type of percentage you want:
To show how each value in a row contributes to the total for the row, click % of Each Row Total.
To show how each value in a column contributes to the total for the column, click % of Each Column Total .
To show how each value in the crosstab contributes to the total for the crosstab, click % of Overall Total.
The % of Overall Total option is available only when there is one overall total for the crosstab. If you insert a stacked set, resulting in multiple totals, the values revert to the default Actual Values.
Tip: To restore the values, right-click the measures corner of the crosstab and click Actual Values.