filter a specific chart within a sheet

[SL2]

Hi everyone, I have a sheet containing 4 charts: bar chart, pie chart, table, treemap. 

And in the table there is a dimension [employee - Yes/No], I wanna filter on 'Yes' for this table while in the other 3 charts (bar chart, pie chart, treemap) there is no such filter on them. Can anyone suggest a way to do that? Thanks.

[jwjackso]

Check Alternate States , you could create an alternate state and assign it to the filter pane and the table.

[SL2]

Thanks, I tried the alter state but it is not working as I expected.

let's say 2 tables : table A and table B in my sheet, table A is like

while table B is full table and it is like

and what I want is, when I play around with the sheet, and set a filter being employee ID = 1

table A and table B both look like:

and if there is no filter then table A should have 2 records while table B have 5 records. Is there a way to do that? thanks.

[SL2 · Accepted solution]

I figure out the way to do that. So we can create a new dimension called [employee - Yes only] which contains only 2 values: 'yes' and null; after dragging this new dimension to the chart, we can uncheck this box in the 'Data' section, which then gives what we want.