Data Split

I have data of products sales in years (FY17, FY18, FY19 & FY20), how can i allocate it to monthly for a given financial year?

Answers

  • Hi,

     

    The keyword you're looking for is YEARVALUE.

    I've attached a simple example of dividing yearly value by 12 below.

     

    Screen Shot 2019-06-22 at 1.02.14 PM.png

     

    Thanks,

    LipChean

  • Thanks LopChean.