Hello, experts. This is easy in python or other programming language. Basically I have two time series S1 and S2 with dates as dimension. I have also created a variable where the user can select a date. In a line graph I'm trying to show S1 and then another line that has S1 plus the values of S2 after the given date. I have tried the following set expression:
=sum(S1) + sum({<Date=">=$(given_date)">} S2)
However it seems that it add the entire S2 series to S1 and ignores the date parameter. Please let know if I need to add more detail or if you have any ideas. Thanks!