Cumulative Total based on Date filter selection.

[MuraliPrasath]

Hi, I'm expecting a below result based on the above table. how to write an expression for this data picker selections on calendar object to get the below result? Need help!

[jochem_zw · Accepted solution]

Make a table, add Country and Product as a dimension

Add an selection filter on field Date, when you select date 1/3/2020

Add this as the measure: sum({$<Date={"<=$(=Max(Date))"}>}Value)

this should do the job, GL

[G3S]

Hi @jochem_zw 

I have a similar situation. 

if my "value" is an aggregation, how should syntax be ?

value is calculated in front end: 

sum(aggr(([CntrTEU]),[CntrSeal]))

I need cumulative of the above based on the date selected in field 'ETSWkEndDate'. I am not clear on how to combine the expression you've provided with the aggregation above. 

I tried the following, but it gives me only for the date selected, not cumulative. 

sum({$<Date={"<=$(=Max(ETSWkEndDate))"}>}aggr([CntrTEU],[CntrSeal]))

Could you please also share why the cumulation is within double quotes?