Hi, I have a table similar to the below:
| Id Number | User | Tag Description | Tag Value |
| 1 | Jack | Country | UK |
| 1 | Jack | Hair Colour | Red |
| 1 | Jack | Shoe Size | 41 |
| 1 | Jack | Profession | Author |
| 2 | John | Country | France |
| 2 | John | Hair Colour | Blue |
| 2 | John | Shoe Size | 45 |
| 2 | John | Profession | Nurse |
| 3 | Mary | Country | UK |
| 3 | Mary | Hair Colour | Green |
| 3 | Mary | Shoe Size | 38 |
| 3 | Mary | Profession | Finance |
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?
