1 Reply Latest reply on Nov 6, 2018 11:01 AM by Patrick Van Der Hyde

    Dynamic Date Filters/Parameters comparing previous dates


      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.