Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=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.
Hi @nilesh_gawali ,
Maybe this:
Sum({< Date = {"$(=Date(Max(Floor(Date))))"}>} value )
I hope it can helps.
Best Regards
try this
Sum({<Date = {"=Date = Max(Date)"}>} Value)
Thank you @Chanty4u