Display totals/percentages (Tables)

To display your data as row and column totals or percentages, use the "Totals and percentages" button on the toolbar.

To apply totals or percentages to the current report, select one of the options:

• Row total (The total of all the values in a row)
• Column total (The total of all the values in a column)
• Percentage of row total
• Percentage of column total

Once you have chosen an option, a checkmark appears beside it. Click on a selected option to deselect it.

• Totals appear as the first item in the innermost row or column dimension. Total cells are a different color than regular data cells.
• Percentages replace all the data values in the current report. They are displayed with a percentage sign (%).

  Note: Display totals/percentages is only active if totals, percentages, or both have been enabled by the Administrator.

Notes on totals and percentages:

• Totals and percentages are calculated based on the current selections along the innermost row or column dimension. (Total and percentage calculations can apply to a maximum of 8,000 items.)
• Percentage values are calculated by dividing each data value by the sum of the items in the innermost dimension. (Missing values are treated as zeroes in percentage calculations.) (Note: Sort arrows do not appear if percentages have been applied to the data.)
• You can save a report that has totals or percentages applied to it in your My reports folder. The totals or percentages will appear in the saved report.
• Total and percentage options persist until you change them, or until you choose to view the same or a different report in the Reports tab.
• Drilling down into a group item causes the totals or percentages to be recalculated.