Managing Percent of Total Calculations in Tables :: SAS(R) Web Report Studio 4.31: 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 list does not contain existing percent of total calculations.
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 type of percentage that you want to show. 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 type of percentage that you want to show. 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 percent of total calculation.
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 add any percent of total items in a multidimensional crosstabulation table, you also see the corresponding total or subtotal items.

Crosstabulation Table with a Percent of Total Calculation

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.

Modify the Number of Decimal Places for a Percent of Total Calculation

By default, percent of total calculations have two decimal places. To change the number of decimal places, complete these steps:

Right-click the percent of total column heading, and then select Format.
In the Define a Format dialog box, change the value in the Decimal places field.

In this example, the number of decimal places has changed from 2 to 4.

Define a Format Dialog Box for Numbers
Click OK.

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.