In my visualisations, I have built pie charts for "Tag Description" column so that each is displayed in a pie chart. However, when I select one of the variables such as "UK" for "Country", all the other pie charts stop displaying since the other rows are ignored.
I currently use =If([Tag Description] like '*Country*', [Tag Value]). How can I use something like an index match to match values and sync across their shared Id Number column?
