32 Replies Latest reply: Nov 8, 2017 10:37 AM by Mike Slottje RSS

    Full accumulation - showing a period

    Mike Slottje

      Hi guys,

       

      I'm facing a problem in my line chart.

      I want to show the accumulated sum of a bank balance, but only for this year.

      To do so, I'm using the following script with MonthYear as dimension:

      rangesum(above(sum([GL Amount USD]),0,rowno()))

       

      This script is working fine when I'm showing the bank balance as a line chart over all the years in our database.

      When I'm selecting to show only the current year, the script above is starting to accumulate with the first month of the current year as starting point.

       

      How could I make a chart where the bank balance is fully accumulated over all the years, but where only the current year is displayed?


      Thanks a lot in advance!:)

       

      Cheers,

      Mike