How to get the Average sales value

Hello, is there a way to obtain the average sales per customer over the past 12 months or any other period? For instance, if I have three customers with sales of £500, £1000, and £3000, I would like to see all of these sales figures listed together and then calculate the average value, which would be £1000. Thank you.

Hello @mbong

There is not a report for average but you can get the total net or total gross for a period. using the search in the clients screen.

To get an average the way you want it you would have to run a backup and use the Sales_invoice.CSV file to give you a list of ALL of the invoices and use Excel(or similar) to filter by date/client etc