Allow selective updates on an input table
I have a module which i have designed for input. The module is based on Time (months) and Versions list (Custom versions not Anaplan built in version). The input module therefore looks something like this:
|Versions (drop down)|
Now i have another module which helps me set the current month and align 3 different versions
|Current Month + 1||Calculated|
|Current Month + 2||Calculated|
So in the above module the user can define what the current month is and also set what version belongs to Actuals, what belongs to Estimate 1 and what to Estimate 2. I use this module to show the comparison between the three versions chosen.
Now i want my input module on top to be driven off the 2nd module both of which i intend to publish to a dashboard for the users to use. Below is what i want to accomplish
When i choose the Current Month (Say Feb 2018), i should be able to only input data for month of February and the input should automatically pull in Jan 2018 data which would have been entered last month. None of the other months should be available for entry.