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

CapabilityRendered report / PDFCSV 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 (or AVERAGE, 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 CSV

CSV 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.


Did this page help you?