1 of 1 people found this helpful
The simple way to achieve this would be to create 2 date parameters.
One we can name "on or before" and the other we can name "on or after"
Create 2 identical sheets with your sum(Number of Records)
Create two calculations, one will filter each of our sheets.
[Date field] >= [On or after]
[Date field] <= [On or before]
[Date field] >= dateadd('year',-1,[On or after)
[Date field] <= dateadd('year',-1,[On or before)
if you apply calculation 1 to sheet 1, and calculation 2 to sheet 2, checking the 'True' box for the filter options, you should achieve your result.
Happy to talk through any additional questions you have.
Thanks a lot that was helpful.