Hi All,

I'm new to Tableau and am having a bit of trouble handling multiple(~23) dimensions that are Y/N.

I want to create a dropdown that lists all of the services as a potential option. Once the service has been selected from the dropdown, user will choose between a 'Y' or 'N' value list.This will bring up the count of data where there is a 'Y' for the selected dimension.

for example: I want to see all opportunities that have a Mechanical Service. I would choose Mechanical from the dropdown, and select 'Y' from the value list. This will produce a bar graph count of the opportunities with mechanical services related to it.

I cannot attach a workbook as the data I am working with is confidential. I have attached a screenshot of what I have so far.

Hope to hear back, Thanks.