How do I create a reporting forecast FTE module based on a time-dimensioned actuals module?
I have a monthly report for employees actual FTE, start date and leave date. I import this into a module:
* Dimensions: People, Time
* Line items: FTE, Start Date, Leave Date
The forecasting for future month should be: Previous total + New joiner that month - New leaver that month.
So if I look on the September data my line items (FTE, Start Date, Leave Date) are totally blank. But I have people starting/leaving that month, which I can see if I toggle back to current month (or further back for that sake).
How can I get the forecast data into a reporting module based on time and FTEs? Do I need to create a separate module without the time dimension that feeds the reporting module?