We run Sage 200 and I'm trying to produce a report that shows our Customers average time to pay. The Account Details report under SL - Reports - Account Analysis gives me the information I need, however it shows the Average Time to Pay for the entire history of the customer. Even when I filter the report to only show accounts that have had transactions on their account in the past 18 months I still get the average times for their entire history.

Is there a way I can filter this report, or is there a better report I can use that will give me the average time to pay by each of our customers over a set period rather than their entire history?