Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Check Alternate States , you could create an alternate state and assign it to the filter pane and the table.
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.
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.