5 Replies Latest reply on Mar 12, 2018 7:46 AM by Vasu choudhury

    MTD/QTD/YTD without Parameter

    Vasu choudhury



      I have seen many blogs which are based on parameters & today(). But none of them meet our requirements.


      I have a month filter and need to display the running sum for different measures in the same sheet(if possible or any other work around).

      When Feb-17 is selected from drop down(single select) then measures with running sum to be displayed for MTD/QTD/YTD as..


      MTD: running SUM(Sales) from 1st Feb to 28th Feb 2017

      QTD: running SUM(Sales) from 1st Jan to 28th Feb 2017

      YTD: running SUM(Sales) from  1st Jan to 28th Feb 2017.


      Note: Month Field has 1//2017, 2/1/2017, 3/1/2017 etc populated in our Data Model.


      Please let me know for any other work around.