Actual vs Last Year

Options
mmhtwe
mmhtwe Member, ALL USERS, Certified Model Builder Posts: 3 New Contributor

I would like to store last year actual value in version. So my version willl have Actual, Last Year and Act vs LY Variance.

 

Can I achive it using formula in Version setting?

 

Thanks and regards,

Maung Maung

Comments

  • mmhtwe
    mmhtwe Member, ALL USERS, Certified Model Builder Posts: 3 New Contributor

    Hi Lip Chean,

     

    Thanks for the suggestion. I want to achieve account and version as cross dimension. Otherwise, I will have to another line item for each account. The screen shot is the sample.

     

    Thanks and regards,

    Maung Maung

     

     

  • mmhtwe
    mmhtwe Member, ALL USERS, Certified Model Builder Posts: 3 New Contributor

    Version_Cross_Dimension.jpg