SUM(VALUES) based on MAX of another value

[nilesh_gawali]

=Max(Aggr(Sum(value), Date))  => this expression is giving max(sum(values), I want sum(values) for max date in provided range.

As soon as we select a date range, I want the sum of values (from another column) of the maximum date for that range.

e.g. If I select the range 1-Jan to 4-Feb and the maximum date present is 28-Jan, then it should take a sum of values (present in another column) for 28-Jan.

[agigliotti]

Hi @nilesh_gawali ,

Maybe this:

Sum({<  Date = {"$(=Date(Max(Floor(Date))))"}>} value )

I hope it can helps.

Best Regards

[Chanty4u · Accepted solution]

try this

Sum({<Date = {"=Date = Max(Date)"}>} Value)

[nilesh_gawali]

Thank you @Chanty4u