Question: In Demand Management, How to use Moving_Total Function to exclude past one month while per

Summary

Question: In Demand Management, How to use Moving_Total Function to exclude past one month while performing summation

Content

Hi Team,

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.

Thanks,

Ramesh