I would like to create a simple bar chart and a input control.
I have two dimensions (Time, Product) and two measures (AC,PY ) as you can see in the screenshot:
It looks like that:
To get the PY I did a calculation:
But now I just want to see only the year on the timeline, which I choose in the input control (2019).
It should look like that:
But that's the way it looks:
The PY is no longer displayed because it isn't in the input control. I guess the input control controls the global data area and throws the PY out. The same thing happens with variances.
Can someone help me with that?