Hey all.

My goal here is to create a parameter that shows several date options compared to their previous counterparts. Such as Week over previous week, last 2 weeks compared to the 2 weeks before etc. My data updates every day and I exclude Today. This would be simple enough for a static report type situation, but am looking for dynamic filters/parameters.

You can see in the screenshot:

I am also using some table calcs. Current period, previous period, % difference.

Is this something you recommend and is possible/sturdy enough to implement in an automatic daily report?

Thanks for the thoughts. Workbook attached.