3 Replies Latest reply: Nov 17, 2017 8:48 AM by Wim Embrechts RSS

    Previous week based on today

    Wim Embrechts



      I have a document where I want to display the sales figures of previous week.

      Example: If today is week 46, then I want to display only the sales of week 45. I don't want the weeks before week 45 displayed.


      Can anyone assist on how to write this in the script because after two days I don't seem to find the right way...


      The idea is creating a new dimension PreviousWeek which will only display the data for week(Today())-1.


      I added an example file.


      Many thanks for your assistance