I'm sure what I'm looking to do is not that difficult, I just can't find a way to achieve it. What I have is a sheet that consists of quote amounts ($) that are relative to a quote date. What I want to do is to look at how many dollars we have quoted that are on quotes a month old, 2 months old, etc.
Ideally this would be something that I could write with a formula right in my current Open Quotes sheet, but if I have to do it with a Report, then I will. I see in the report builder that I can make a report based on a specific date, but that would require that I go into the report and constantly update the date. What I want is a constantly up to date solution that is always looking...
Is there a clean way of achieving this?