Help Center

How to add quantity to reports

Add quantity to any Customers tab report, then use it in any metric definition, report row, or formula.


1. Add quantity to a report

  1. Create a new report (see How to create a new report on the customers page; how to use customer page reports throughout the system) or click on Configure Report or the three dots next to the report name and select Edit report to configure an existing one.
Report sidebar menu with the three dots and Edit report option highlighted
  1. In the Configure Report menu, select Display, then Data To Display.
  2. Check the box for Quantity.
  3. Click Done.
Configure Report with Display open, the Data To Display menu showing Quantity, and Done highlighted

Any breakdown rows you have selected - New, Lost, Upgraded, Downgraded, and Reactivated - apply across every selected metric, so checking Quantity also gives you new, lost, upgraded, downgraded, and reactivated quantity alongside the equivalent revenue and customer rows.


2. Use quantity in metrics and formulas

  1. To use quantity in a formula, select quantity (or whatever name you have assigned to it).
  2. Select the Customers tab report you wish to use.
Row picker searched for quantity, with Quantity ticked and the Select report list open

Read more in How to create or edit a formula in a report and How to edit a metric and change the way a metric is calculated (how to change a formula).


Rename quantity

To change the name by which quantity is displayed, see How to change the quantity label in ScaleXP reports. Once the name is changed, the new name will appear in the report configuration menus as well as on the reports themselves.


Set how quantity totals over longer periods

To manage how quantity appears in year to date, quarter to date, and other cumulative time periods, see How to change the way quantity is reported in ScaleXP reports for different time periods.