Append Filter on Previous Period to Current
I have a report with a user prompt filter which has a default setting of pre-defined period 'Last Calendar Month'. So they can change it to a custom range if required.
Trying to build out a report to show the performance gains/losses against a previous period.
I have the primary filter set with the pre-defined period 'Last Calendar Month', I am trying to figure out a way of linking the secondary filter in the append to the primary query with dynamic date adjustment.
ie count the days in the primary filter range, then subtract that from the secondary filter dates ExampleLast calendar month was December 1-31 (31 days)
So the benchmarked period would be Oct 31 - Nov 30
Alternatively benchmarking it against the calendar months Dec vs Nov ignoring the day diff
So far I can only see the ability to link and then hardcode in a diff # days/weeks/months etc