1 Reply Latest reply on Jun 19, 2018 2:25 PM by Patrick Van Der Hyde

    Moving calculations

    Prajval T

      Hi Team,


      I need to show the data for rolling 6 months avg sales on each month and, after calculating rolling 6 months i need to show MTD, QTD and YTD data in the text table with some KPI indication like mentioned below.

      But when i tried doing that i am not able to get properly.


      Can you please help me out, how to get MTD, QTD and YTD as per the calulations i have mentioned in the attached .tqbx file.


      I when i tried doing that i am getting view like below.

      Prev MTD and MTD should have one value, but i am getting 3 values bcf of Month(orderdate ) in the details .

      But if i did not added orderdate to the details rolling 6 months is not working where i have used look up().