1) Head to Reports >> Revenue > Invoices
​
2) Click on >> Any time >> Custom to select a specific date range >> ‘Download CSV’.
​
3) In your Excel file top menu, go to Insert, select “Pivot Chart” and accept.
​
4) Once done, a new sheet will open with a blank pivot table. Here you’ll need to click and drag “Customer” into Rows/Axis and "Total" into Values. By default, Values will be set to ‘Count’.

Right-click on the "Total" field >> click Field Settings and choose the ‘Sum’ option.

This will give you the total amount spent by each customer.
​
Please contact our support team if you'd like any further guidance at all.
​
​Jump to:
​
​How to generate an average customer lifespan report
​
​How to determine revenue per class type or per instructor