I am creating a rolling forecast/ budget. Time and Category will be picked up from Row1 and 2. I am doing budget for 5 years. I am using local members to calculate q1,q2,q3,q4 for current year since it will be mix of actuals and forecast. future years is always budget.
When I use EPM Pane to add a new row member, my first year data gets repeated multiple times at the end of the report and also local members disappear, also the cell reference from Time and Category to Row 1 and 2 of excel sheet gets into disarray.
Anyone has experienced this before ? Any suggestions would be appreciated.