4 Replies Latest reply on Aug 28, 2017 8:34 AM by Felix Amankwah

    YTD Calcuated Field

    alex.kim.6

      Hello Community!

       

      I need your help setting up a calculated field.

       

      My current dataset is designed as below. I want to add a calculated field as a column but encountered a problem.

       

      So basically, when April is selected "in the filter" the value in the April YTD should represent the sum value of January through April.

       

      First of all, should I use Parameter for this function? and how should I create the calculated field for the YTD value?

       

      Thanks for the help!

       

       

       

      MonthData(YTD) Calcuated field
      1/1/201710
      2/1/201720
      3/1/201730
      4/1/201740
      5/1/201750