Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi @lg92 ,
Maybe this:
=Sum( {< YearDate = {"<=$(=Max(YearDate))"} >} Amount )
I hope it can help.
Best Regards
=sum({<YearDate={"<=$(=max(YearDate))"}>} Amount)
@lg92 like ?
=sum({<YearDate={"<=$(=getfieldselections(YearDate))"}>} Amount)
example :
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
Hi @lg92 ,
Maybe this:
=Sum( {< YearDate = {"<=$(=Max(YearDate))"} >} Amount )
I hope it can help.
Best Regards
=sum({<YearDate={"<=$(=max(YearDate))"}>} Amount)