Get monthly value for base year selected
I have a module (dimesioned monthly) in which I need the base year values. The user selects the base year.
I have created a seperate module in which the user can select the base year. However, when I am using the base year in the lookup, I am getting the full year value, instead of monthly value.
if user selects 2022 as base then
JAN23 FEB23 MAR23 …………………..
Value 100 120 110
Base Value 90 115 105 (jan 22, feb 22, mar 22 values)