Managing Percent of Total Calculations in Tables :: SAS(R) Web Report Studio 4.2: User's Guide

About the Different Calculations That You Can Create

For tables that use relational data, you can add a column that shows a selected measure as a percentage of a grand total. For relational crosstabulation tables, you can show a selected measure as a percentage of a grand total, a column total, a row total, or a subtotal. For multidimensional crosstabulation tables, you can show a selected measure as a percentage of a grand total, a column total, a row total, a column subtotal, or a row subtotal.

Add a Percent of Total Calculation to a Table

To add a percent of total calculation to a table, complete these steps:

Right-click on the table, and then select Percent of Total to open the Percent of Total dialog box. The Percent of Total menu item is not available if either of these conditions exists:
- The table does not contain any measures that can be used in a grand total.
- The table is in a synchronized group.
In the For measure drop-down list, select a measure for the calculation. The following restrictions apply:
- The list does not contain existing percent of total calculations.
- The list contains only those measures that make sense for a grand total calculation.
In the Show percent of drop-down list, select an option, depending on the type of table:
- For list tables, the Column Total option is the only type of percent of total that is supported.
- For relational crosstabulation tables, for the selected measure, select the value that you want to calculate the measure as a percentage of. Your predefined choices are Grand Total, Column Total, and Row Total. The drop-down list also contains these options:
  
  one option for the subtotal of each category in the columns of the table. The options are listed in order from the top down.
  
  one option for the subtotal of each category in the rows of the table. The options are listed in order from the outside inward.
- For multidimensional crosstabulation tables, for the selected measure, select the value that you want to calculate the measure as a percent of total of. The available choices are Grand Total, Column Total, Column Subtotal, and Row Subtotal.
Type a Label for the calculation that you are creating. You can use a maximum of 30 characters. The Label field is initially blank. The Add button is not available until you enter a value into this field.
Click Add to add your For measure, Show percent of, and Label selections to the box.
Click OK.

When the measure that is used in the calculation appears in a column, the new calculation appears immediately to the right of the measure. When the measure that is used in the calculation appears in a row, the new calculation appears immediately below the measure.

Note: If you ask for any percent of total items in a multidimensional crosstabulation table, you also see the corresponding total or subtotal items.

If you use the Properties dialog box to convert a crosstabulation table to a list table, then the following happens:

All percent of grand total items become percent of column items.
Any other percent of total items are removed, because they are not supported for list tables. You are asked to confirm the removal of these percent of total items.

Remove a Percent of Total Calculation from a Table

To remove a percent of total calculation from a table, complete these steps:

Right-click on the table, and then select Percent of Total to open the Percent of Total dialog box.
Select a calculation.
Click Remove.
Click OK.

Note: If you use the Select Data dialog box to remove a data item from your query, then any percent of total calculations that depend on it are automatically removed from your table.