0 Replies Latest reply on Sep 27, 2018 3:34 PM by john.brothers.0

    Dynamic Date Filters/Parameters comparing previous dates

    john.brothers.0

      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.