Sum all the previous values since the date

[alejortizp]

Hi guys,

I am trying to select a date and when select that date sum all the previous values since the date i had chosen.

Thanks for all.

[JaMajka1 · Accepted solution]

Hi Alejandro,

You could define variable v_date_filter = GetFieldSelections(date_field) and then use it in expression of KPI with set analysis:

sum({$<date_new={'<=$(v_date_filter)'}>}value)

Hope it helps ,

Maria