How Totals, Subtotals, and Percent of Total Calculations Can Help with Analysis

Summarizing data provides a fast way to understand how a group of data values are performing and how subgroups compare to one another. SAS Web Report Studio enables you to display the measures summarized, such as a summation or average, at one or multiple levels within tables. A summary for all values is called a total and a summary for a subgroup of values is called a subtotal. These totals and subtotals can be displayed above or below the group of values (for multidimensional data sources only). You can choose to add totals and subtotals for rows, columns, or both. When you need to understand how an individual item contributes to a group of values, you can add table cells to display the percent that value represents of the overall total, subtotal, or both. Totals, subtotals, and percent of total calculations help you evaluate metrics at higher levels and compare groups at the same level to determine where to focus your analysis.