14 Replies Latest reply on Jun 26, 2018 7:15 AM by Mavis Liu

    Cumlative Sum YoY MoM in one worksheet

    Deepika Goyal

      HIi Team,

       

      Need your help here.

       

      Attached book is for you reference.

       

      I have two data sets (Cost and revenue) and i am trying to calculate below 3 things:

      1. Cost income ratio ( This is YTD)

      2. CIR comparison with last year : YoY

      3. CIR comparision with previous month:  MoM

       

      I have tried using running sum to arrive at YTD but then i am unable to do 2 and 3 points

      If i restrict my view at year level then 1 point can be acheived easily but again for comparision values are returning wrong.

       

       

      Can you please help

       

       

       

      Regards,

      Deepika