2 Replies Latest reply on Aug 20, 2018 7:50 AM by shaheen.haque.1

    YoY calculation of running total value.

    shaheen.haque.1

      Hello,

       

      I am struggling with a table calculation. I need to create a Year on Year compassion and my data is on daily level for two years. In the attached workbook you can see that i have a calculated field(Total Value per thousand ) whose calculation is based on last value of "Total Member" and the running sum of "Total value". So basically i need to have YoY of the field "Total Value per thousand". For instance: if the date range is till 1/5/2018 then i should get YOY based on value 1.25 and 2.73 as per my sample data. Hope i am clear here.