Hi everyone, I'm trying to get the AR Aging total for each column (Current, 30 Days, 60 Days, 90 Days, > 90 days) for each month (Jan 2024 - Oct 2024) but when I change the AR Aging Report as of date to Jan 31, it's showing me data relative to now. I want to know on January 31, what was the total for Current, 30 Day, 60 Day, etc and the same for each month. I tried to create a saved search with formulas to give this data, but couldn't get it to work properly. Is this possible to do?

Notice, that you have to set two dates, to show the data correctly:

It's one of those days for me lol Thank you so much 🙂