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