I have un pivoted data displayed in a text table and would like to filter IDs from a different column value. For example, from the worksheet provided. I want to be able to filter on color but have the filter be applied to the ID

The filter I'm using was created via. a calculated field

IIF([CODE] = 'color', [VALUE],NULL)