3 Replies Latest reply on Sep 20, 2018 2:59 AM by Jim Dehner

    Running totals function to stop on a given period.

    oscar vicente

      Dear all good morning,

      I have a simple question, I have a measure for which i have three categories, FEB, SEP , ACT.

      The first two are planning figures which are monthly plan which extend beyond the current period till end of the year,  the third is actual cost, which only run until current period.

      When i apply running totals function to my measure by default for the third category ACT i have line  till end of the year, however i would like it finish plotting after the current period, while for the other two not.

      I embed a screenshot below for further clarification.

      Is there a way to say the running total to stop for only one of the categories, or only to go for a calculated field creating another measure.

      Thanks

      oscar