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().