Historical values - to be partly independent from user_selections
Hi,
I have a combochart and, next to it, another one to display historical values:
- the value we had last week
- the value we had last month.
The trick is this: The historical values should be independent of user_selections concerning the time, but should take into account user_selections on plant and area.
Currently, I have the following set_expression to accomplish that:
- prior month: >>> (sum({1<Jahr = {$(=year(monthstart(today(), -1)))}, Monat = {$(=Month(monthstart(TODAY())-1))}, Werk = P(Werk), Bereich = P(Bereich)>}Schadenshöhe), '#.##0,00 €') <<<
- prior week: >>> (sum({1<Jahr = {$(=year(today()))}, Woche = {$(=(Week(today())-1))}, Werk = P(Werk), Bereich = P(Bereich)>}Schadenshöhe), '#.##0,00 €') <<<
=> The problem is this: When I have no time-wise user_selections at all, that works fine
<=> When 2014, cw 2 is selected (standard), that implies only one plant is selectable and the value for the prior month changes.
