6 Replies Latest reply on Jan 10, 2018 3:48 AM by Norbert Maijoor

    Automatically Show Last Weeks Profit vs This Time Last Years Profit

    Ali Ahmad

      Hi Everyone,

       

      I need a table that shows the following;

       

      Year     Week Number     Profit

      2017               1                    100

      2016               1                      80

       

      I have managed to get the above working by filtering on "Year" for 2017 and 2016, and filtering Week Number to 1.

       

       

       

      How do I now set this up so that it shows Last weeks profit automatically. I.e. if you are in week 3, it'll automatically update the table to show week 2 profits this year vs last year.

       

      If I do a "Relative Date" on Week, it only shows LAST WEEKS profit (and not 2016 week 1 profits).

       

      Any help would be appreciated!

       

       

      Thanks