Formula to populate lime item with months for a selected year
I have a Masterfile module that has lines items that use a select function to get the data for a specific month. However, I am now trying to make the module dynamic. This means that the end user can select a year and the module is updated with the months in the selected year.
I have created a "Masterfile - Time" module were the desired year can be selected but what formula can I use to populate the line items with the months of the selected year?
Secondly, please find attached an image of the how to the formula is the masterfile uses a LOOKUP function to the Masterfile-Time module.
Please let me know if any further clarification is needed.
Many thanks in advance!
What formula should i use to get Feb and Mar filled in?The module looks up on the appropriate month in the Masterfile-Time module
The non-time dimensioned data should show alongside the 'revenue' line item in the same fashion as any other line item. The fact that time has been added as a dimension should not have an impact on no-time dimensioned data.