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

    Previous week based on today

    Wim Embrechts

      Hi,

       

      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

       

      Wim