Prior Year data Pull with diffrent time range

Frequent Contributor

Prior Year data Pull with diffrent time range

Hi All,

 

Need a function help here, I have 2 modules Module 1 and Module 2

 

both uses time dimension and different time range.

 

In my Lineitem A for Module 1 in (FY20) ,I want to Pull in previous year data value from module 2 lineitemB i,e (FY19) data.

 

Line Item A = Module 2.Line item B( but this should pick my prior year data value).

say I FY20 it should pull FY19 data.

 

I have tried creating a system module with current year and Prior year as FY20 and FY19 and do Lookup.

but this does not work.

 

Lag, Post and anysuch function doesnot work as my time range are diff in source and target.

 

 

 

 

Regards,

Madhu

1 REPLY 1
Highlighted
Master Anaplanner/Community Boss

Re: Prior Year data Pull with diffrent time range

@MadhabikaM 

 

See if this helps

 

SYS Time Module

Misbah_0-1597401681434.png

 

Source Module

Misbah_2-1597401752146.png

 

 

Target Module

Misbah_1-1597401731471.png

Misbah