"forecasting"
1 Topic
Forecasting current month based on previous month - measure
Hi Community, I want to create a report/table that shows the following information: . Country . qty sales (month to date) - measure already exists . qty sales last month (total month) - measure already exists . qty sales CM Total (forecast current month based on previous month) - need to create . variance qty sales (month to date) - need to create Example below: Date = 14 Nov MTD October (total) Forecast November (total) var CM/LM (MTD) United States 800 1500 1714 18% France 220 450 471 8% Germany 200 500 429 -11% Spain 175 400 375 -3% Can you help me? Thank you!Solved1.6KViews1like4Comments