Full accumulation - showing a period

[Anonymous]

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

[Anonymous]

I don't fully understand what you mean..

That's what we already did isn't it?

Oh edit *

How should we get current year as Year={$(=Year(Today()))} and prior year as {$(=Year(Today())-1)}etc. in this expression?

[sunny_talwar]

May be this

Only({<Year = {'$(=Year(Today()))', '$(=Year(Today())-1)'}>} Aggr(RangeSum(Above(TOTAL Sum({<Year, Date, MonthYear, Month>}[GL Amount USD]), 0, RowNo(TOTAL))), Year, (Month, (NUMERIC))))

[Anonymous]

Yep! That's it! You're officially the MVP today