Cumulative Sum

[lg92]

Hi,

I have this table

YearDate   Amount
2019          1000
2019          20000
2018         4550
2020         45480
2019         3200
2019         23320
2021        32780
2021        12370
2021         12300
2020        24890
2018         6580
2019          68750
2020         237890
2021         21330
2021        54560

I need to develp a KPI that calculate cumulative sum by years. if i filter year = 2020, the kpi sum 2018 + 2019 + 2020.

Thanks in advanced 

[Taoufiq_Zarra]

@lg92  like ?

=sum({<YearDate={"<=$(=getfieldselections(YearDate))"}>} Amount)

example :

[lg92]

This solution works only if i select one year. I need that works also if i don't select any year (in this case kpi sum 2018 +2019+2020+2021 as default).
anyway thank you

[agigliotti · Accepted solution]

Hi @lg92 ,

Maybe this:

=Sum( {< YearDate = {"<=$(=Max(YearDate))"} >} Amount )

I hope it can help.

Best Regards

[Taoufiq_Zarra · Accepted solution]

=sum({<YearDate={"<=$(=max(YearDate))"}>} Amount)