Reporting 2.0 - Only Show Summary Rows

Note: This feature was first announced as part of the July '21 release.

A new Only Show Summary Rows option is added to the Table Properties panel. When toggled on, the report output will only show summarized and aggregated fields and it will not include the rows for the underlying data in the report.

Considerations for Charts

When using the Only Show Summary Rows option in combination with a chart, the aggregation is driven by the selection made on the field in Column Header Properties. With that the aggregation operation for the measure field on the Chart is also no longer shown. If you have defined a chart before, but the Chart Measure and Field Aggregation are not in sync, the Only Show Summary Rows will be disabled until the two are in sync. For example, if you chose Count in the Apply Aggregation field on the Column Header Properties panel, then Count needs to be selected in the Measure field on the chart to get the fields in sync and enable the Only Show Summary Rows option.


Upon implementation, this functionality is available in all portals with Reporting 2.0.

Click here to download the Reporting 2.0 Starter Guide.

Click here to download the Reporting 2.0 Adoption Kit.


For more information about Reporting 2.0 permissions, see the following:

  • Permissions in Reporting 2.0 - This provides detailed information about Reporting 2.0 permissions.
  • Permissions List - This provides the list of permissions and their relationships so that you know which permissions users need to have to create and view reports.