Compare period with same period last year in pivot table

Question & Answer
,
1

Hello,

I currently have a pivot table that shows rental information for my product broken down by region. This data is filtered by a Start and End date parameter as seen in this screenshot:

Screen Shot 2022-07-19 at 9.55.09 AM
Screen Shot 2022-07-19 at 9.55.09 AM2114×938 88.9 KB

I want to add a Year-over-Year capability to this table so that in addition to seeing data in the selected date range, we also see the data in the same month/day range for the previous year. So n this example, we are viewing data from June 15, 2022 to July 31, 2022, but I also want to show data between June 15, 2021 and July 31, 2021.

I appreciate any suggestions on how this might be possible!

2

@TheCardlessMoose - try writing a calculated field like this:

ifelse(({your date field}>=${start parameter} AND {your date field}<=${end parameter}) OR ({your date field}>=addDateTime(-1, ‘YYYY’, ${start parameter}) AND {your date field}<=addDateTime(-1, ‘YYYY’, ${endparameter}), 1, 0)

Then add a filter on that calculated field and set it =1. Also remove any other date filters you have on your visual (this should be the only date filter).