Report Builder: custom reports — save, filter and export

Build your own sales reports by choosing a metric, grouping, filters and chart type, then save them to reuse anytime.

Jun 26, 2026

The Report Builder lets you assemble sales reports your way, without being limited to the fixed reports. You choose what to measure, how to group it, what to filter and how to view it, then save it to run again whenever you need.

When it helps

  • When the standard Sales reports don't answer your exact question.
  • For recurring reports (e.g. "Won amount by rep this quarter").
  • To cross two deal dimensions the fixed report won't combine.

Requirements

  • CRM module enabled on your plan.
  • Deals loaded in at least one pipeline.

Steps

  1. Open the CRM, go to Reports and click Report Builder (or go to /crm/reports/builder).
  2. Pick the Metric: Deal count, Total amount, Average amount, or Win rate.
  3. Pick Group by (dimension): Seller, Source, Stage, Pipeline, Win/loss reason, Month, or Status.
  4. Set the Filters: period, status (Open/Won/Lost), seller, pipeline, and minimum amount.
  5. Choose the Chart: Bar, Pie, Line, or Table.
  6. Click Run to see the result.

Save and reuse

  • Type a Report name and click Save report. It appears under Saved reports.
  • To view it again, open it from that list (it runs against fresh data).
  • You can Update a saved report (change its config) or Delete ones you no longer need. New report clears the canvas.

Export

Switch the chart to Table to see rows with Group and Value. From there you can copy the data into your spreadsheet, or print/save as PDF using your browser's print option. Because saved reports always run on live data, they're the most reliable way to "export" the same analysis every period.

Verify

The table total should match the equivalent standard report (e.g. Total amount Won for the period should equal the Dashboard's "Won value" for the same range).

If it doesn't work

  • "No data for this configuration": your filters are too tight (status + period + minimum amount combo). Loosen them.
  • Your saved report doesn't appear: confirm you saved it with a name; without a name it isn't persisted.
  • Odd Win rate numbers: remember it only counts closed deals (won over won+lost), not open ones.

Tips

  • Start from the question ("which rep closes the most amount?") and derive the metric + dimension from it.
  • Keep a small library: one per rep, one per source, one per loss reason.

Related articles

Was this helpful?

Related articles

Message us on WhatsApp