Set analysis for time range dependent on selection

[Anonymous]

Hello!

I have a table with IDs and associated times and values. Now I want to show in a table diagramm the maximum value of all entries, which are in a time certain time range around the selection.

I imagined something like this, which doesn't seem to be correct, yet.

max({$<ID = , Time <= AddMonths(max(Time), 1)>} Value)

also tried

max({$<ID = , Time <= $(=AddMonths(max(Time), 1))>} Value)

but to no avail. Am I on the right track?

Regards,

Sandro

[felcar2013]

maybe you can try

max({$<ID = , Time={"<= $(=AddMonths(max(Time), 1))"}>} Value)

[Anonymous]

Can't make that work either. Wouldn't the expression in quotes also evaluate to a boolean? And when comparing Time to it, never get me anywhere?

Either way. Unfortunately, not yet the solution

Sandro