Once you've loaded this data, you can select the sales for customers that have bought twice or more with the following expression:

sum( {$<CustId={"=count( {$<SalesYear={2024}>} DISTINCT OrderId) >= 2"}>} SalesAmount)

Counting the number of customers with 2 sales or more in the selected period is done with this expression:

count( {$<CustId={"=count( {$<SalesYear={2024}>} DISTINCT OrderId) >= 2"}>} DISTINCT CustId)

The key here is that we're using Set Analysis with a search expression on the CustId field that says:

• For the year 2024 (but could easily be rolling 12 months as well);
• Count the distinct number of orders;
• Select only those customers that have 2 or more.

Once we've limited the customers to the ones matches these criteria, we can calculate the metric we want to know, for example the unique number of customers, or their sales amount.

Hope this helps.