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!