Hello Everyone,
I have two modules as mentioned below.I need to get data from module1 Jan20 to module2 Jan21 and same follows for other months.
Module1
Time Scale -FY20(jan to Dem)
Line item - Data
Module2
Time Range -FY21(jan to dec)
line item-data1
Can someone help me with this.
Thanks
Tejaswini
You will have to include FY20 as well in your Target module.
Get FY20 data from the source module in Line 1
In Line 2 - Use OFFSET or LAG function to pull the values forward
For example OFFSET(Line 1, -12,0)
Misbah
Yes this will work.
But is there any other option without including FY20 in our Target module.
Thanks
Tejaswini
You could also create a Month formatted line item with the formula: ITEM(Time) - 12
Either in a system module (if it will be used elsewhere) or in Module 2
Then use that to LOOKUP the value from Module 1