1 of 1 people found this helpful
I am not sure I understand your issue correctly or not anyways.
To make highlight or filter work, that dimension needs to be set in the target sheet.
And change the stack type to "OFF".
That's exactly what I was looking for, thanks!
It has worked perfectly for 3 of my charts but for the "Movie Profits over Time" Chart it seems to have removed a few of the lines- is there a reason for this?