Modeling

Options
AmruthaB
AmruthaB Member, ALL USERS, Certified Model Builder Posts: 5 Contributor
in Planning & Modeling

HI,  Can someone help the below requirement.  Need to get Prior year data, I know to use offset or lag, But for FY, I need to get the data what i have in the prior year (FY) only, when using offset or Lag , I cant use any   other summary except "sum".  Any help would be highly appreciated. 

AmruthaB_0-1622731721943.png

Thanks

 

 

Tagged:

Comments

  • AmruthaB
    AmruthaB Member, ALL USERS, Certified Model Builder Posts: 5 Contributor
    Both my target(I am using lineitem subset) and source has time, for eg, Fy20 = 10 then in FY21 also I need to get 10 only instead of aggregating
  • AmruthaB
    AmruthaB Member, ALL USERS, Certified Model Builder Posts: 5 Contributor

    Both my target(I am using lineitem subset) and source has time, for eg, Fy20 = 10 then in FY21 also I need to get 10 only instead of aggregating

Categories