Question: In Demand Management, How to use Moving_Total Function to exclude past one month while per
SummaryQuestion: In Demand Management, How to use Moving_Total Function to exclude past one month while performing summation
We have an requirement to do Moving_Total for 'Final Shipments History' measure for Past 3 Months. But immediate past month should not be included in moving_total summation.
For Ex: If current month is May then moving_total should be done from Jan to March. (April month should not be included in Moving_total).
can you please suggest on this requirement to how to use this function or use any other function.