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