I have two sets of data sources:
-Groups
-items
Each group may contain any number of items.
Each Group and Item has its own distinct ID.
I am looking for a filter for items, based on groups.
It means that, if I exclude a certain group, I want their respective items to be excluded from my charts, calculations, etc. as well. I can exclude the items in unwanted groups by linking the two datasources by Group ID. BUT, the link also excludes groups with no items in them.
In the attached example, I linked group IDs and filtered for Group type "Orange". There are three groups of that type.
In the Orange groups, there are two items with the name "alpha".
Therefore, the rate for those items must be 2/3. But instead, tableau shows 2/2 = 1. Because one group (Group K) has no items associated to it. hence, it is filtered out.
How can I fix this problem?
2 answers
posted a file.
