Calculate single value column aggregates at a table's highest aggregation level

How to calculate single value column aggregates at a table’s highest aggregation level? Sum(Column Name) is not working.

Summaries can be added to calculate the single value column aggregates.

  1. Click the SUMMARY button, located in the table footer.
  2. Click the section’s plus ( + ) button.
  3. Select a column option.
    New summary creates a new blank summary column and focuses the formula bar. Type your custom formula to create you summary.
  • Row Count* counts the total number of rows at the top most level of the table. If there are no groupings, this calculation will match the total number of table rows. If there are groupings, the calculation will match the total number of groups in the highest grouping.
  • Selecting any of the existing columns will create a summary aggregate of that column. Aggregation type (e.g. Sum vs Count) is dependent on the original column’s value type (e.g. text, number, date, etc).