Find my approach based on "pivoting" the datasource and stored in attached workbook version 10.3 located in the original thread.
1. Pivot your datasource and is explained here
2. Drag the required objects to the indicated locations and filter as depicted.
Multiple Dim_nalmai_10.1.twbx 13.6 KB
1 of 1 people found this helpful
So you could Pivot the data, and then just keep the "yes" rows, or this formula would give you a single column
IF [Type A] = 'Yes' THEN 'Type A'
ELSEIF [Type B] = 'Yes' THEN 'Type B'
ELSEIF [Type C] = 'Yes' THEN 'Type C'
ELSEIF [Type D] = 'Yes' THEN 'Type D'
Hope that helps