CSV Report Exports and Totals Rows
CSV Report Exports and Totals Rows
When you export a report to CSV, the totals (summary) row you see in a rendered report or PDF may not appear in the CSV file. This article explains why and what to do.
What to expect
- CSV export returns the underlying table data, row by row. It is designed to give you the raw records so you can pivot, filter, or re-aggregate the data yourself in a spreadsheet.
- Totals / summary rows are not included in the CSV. Totals shown in a rendered report or a PDF export are presentation-layer summaries. The CSV export does not carry those summary rows into the file.
- CSV export applies to standard table widgets. Pivot-style widgets are not included in CSV export.
Feature parity at a glance
| Capability | Rendered report / PDF | CSV export |
|---|---|---|
| Row-level table data | ✅ Yes | ✅ Yes (standard table widgets) |
| Totals / summary row | ✅ Yes | ❌ Not included |
| Pivot widgets | ✅ Yes | ❌ Not included |
How to get totals from a CSV
Because the CSV contains the full row-level data, you can reproduce any total yourself:
- Open the CSV in your spreadsheet tool and use a
SUM(orAVERAGE, etc.) formula across the relevant column. - If you need the totals presented automatically, use the PDF export or the rendered report view, where the totals row is displayed.
Why totals aren't in the CSVCSV export is intended as a clean, machine-readable extract of the underlying rows so you can do your own analysis. Summary rows are part of how a report is presented, so they live in the rendered report and PDF rather than the raw data export.
Updated 1 day ago
Did this page help you?