Using Breaks and Subtotals in a Report


Breaks and subtotals allow you to divide a report into smaller sections for more granular analysis and a more digestible view of your data. These sections are generated for each value in a selected Row field or after the last value of a selected Column Group field.

To apply a break or subtotal, right-click a field in the Rows or Column Groups bucket, point to Insert breaks, and select an option. Three categories of options are available for row fields: Subtotals, Page breaks, and Row breaks. You can select an option for each of these categories in each row field of a report. For columnar sort fields, only the Subtotal options are available.

Note: The responsive canvas, used for the AHTML and HTML5 output formats, uses AHTML In-Document Analytic capabilities to enable interactive options at design time. When creating a report, page and row break settings are not supported on this canvas, or at runtime when using the AHTML output format. If you select an output format that uses the paginated canvas, such as HTML, PDF, PPTX, or XLSX, you will see these breaks at design time and at runtime.