2 of 2 people found this helpful
Create a calculated field similar to the following:
dateadd('month', -12, today())<=date
Then, place it on the columns shelf (to the far right). Right click on False (on the view) and select Hide. Hiding the data doesn't filter it out and will not change your running totals. However, since False is based on something relative to today, it will update dynamically.
Hope this helps!
Great, thank you so much!