I have a line chart with 4 lines currently
Line Green
Line Orange
Line Red
Line TOTAL (TOTAL is always green + orange + red)
My Data looks like
[Green => 1, Orange => 0, Red => 2, TOTAL => 3],
[Green => 2, Orange => 2, Red => 2, TOTAL => 6],
[Green => 5, Orange => 1, Red => 2, TOTAL => 8],
This means I always pass TOTAL value but issue/feature that I would like to get is that If I unselect Red values from legend it would recalculate TOTAL values to 1,4,6 or If I would unselect also green it would again recalculate TOTAL
Currently if I will unselect Red for example Total value will stay as it is as there is no dependency.
Hope it makes sense.
We have a company license if needed
