Here is solution - 

Go to the Invoices Menu:

Navigate to Accounting → Customers → Invoices.

Apply Filters:

Click on Filters and add:

Status: Posted (To exclude draft invoices)

Invoice Date: Between 01/01/2024 and 12/31/2024

Click Add Custom Filter:

Total Excluding VAT (or untaxed amount) >= 1000

Group By Customer:

Click on Group By → Customer.

This will aggregate invoices per customer.

Use Pivot View:

Switch to Pivot View.

Add:

Customer Name as a row.

Total Excluding VAT as a measure.

Click on Date Filters → Select Year 2024.

Export Data:

Click on "Insert in Spreadsheet"

Or, use List View, select all, and then click Action → Export.

Filter maybe something like last_year_revenue>=10000 if next year you want it to work for 2025.

This is a store calculated field which is the same as your total invoice field but with a domain to restrict records to the previous year only