...
If a ‘Like’ filter is used, a single value from the ‘US State Population’ data table will used. This value will be from the first row in the first column in the table which in this case happens to be California.
...
The resulting ‘County Population’ table showing counties in California only.
...
Chart Notification shows that a filter of ‘California’ has been applied.
...
If an ‘In’ filter is used, multiple values from the ‘US State Population’ data table will be used. These will be values from the first column of the table - in this case, the 10 top states by population that we filtered this table on.
...
Chart Notification show how the filter has been appliedshows that the ‘County Population’ table has been filtered on 10 states - the 10 most populous.
...
The resulting ‘County Population’ table showing only counties in the Top 10 most populous states.
...