Forum Discussion
Malsk1_1
4 years agoHelper II
Data Processing for Actual and Forecast data
Hi, I have the following Actual and Forecasted spend. Month end represents the month end baseline data, planning period represents current and future Actual spend and Forecast spend. Currently ...
Malsk1_1
4 years agoHelper II
PaulDBrown see file located in the share -->
The model is as follows:
Date table is connected to the Month End
I have a Date filter using the Date table to filter out the Month End
I have created the charts i would like to see..
PaulDBrown
4 years agoCommunity Champion
Sorry, does your table only contain the data you have provided?
If you have a date table, can you please share it? together with any other tables.
"the Actual spend is being populated" Where from?
"I have a Date filter using the Date table to filter out the Month End". What does this mean exactly?
Please provide an example as a table of what you are expecting to achieve. I can't figure out what the charts are calculating.
Thanks.