7 Replies Latest reply: Feb 3, 2017 2:20 PM by Sunny Talwar RSS

    WTD, MTD, YTD and running totals

    Piotr Lipski

      Hello,

       

      I would like to prepare very simple report (I thought) but I have some problems with running totals.

       

      I would like to have report with 4 expressions: Current Sales, WTD Sales, MTD Sales and YTD Sales.

       

      Problem which I have is that user need to have possibility to select eg. only one day or random period.

       

      I found two ways for that but both are not perfect.

      • First is when I have in dimension all measures like Year, Month, Week. In such case figures looks fine but I have 5 dimension instead of 2. In final version I really would like to keep it simple with only Store and Date.

      1.png

      • Second option is to use set analysis and TOTAL but in such case I don't have accumulative WTD but only final totals for week.

       

      I tried to find solution with first option but when I keep in dimension only Store and Date I have such things...

      2.png

       

      Last version of my WTD expression looks like below :

      =RangeSum(Above( sum( {<Date=>}Sales),0,7))