To get data for max date when no date is selected in the filter

[Saurabh07]

I am trying to get sum of values in my table for the latest available date when no date is selected in filter.

I am using below expression, but somehow its not working;

sum({<date = {$(=max(date))}>}Value)

Can anyone please help me out with this?

[Saurabh07]

@Taoufiq_Zarra  Great, thanks for the help! Appreciate that!