My task is to make line and clustered chart, showing costs each month, by budget, actual and actual last year with help of year filter on top. That i have done:
https://imgur.com/a/mNcCtpD
but the second task is, if user clicks on , lets say January, he/she will see the months costs as stacked like this:
https://imgur.com/a/LSMVl5d / Budget , Actual and Actual last year
If i try to use same data , Budget, Actual and Actual last year, they will not go into the Axis slot but will stay in Values. In Values i have the costs already. And in Axis i have months. What should i do? If needed, i can always try another chart type.
