1 of 1 people found this helpful
Just a quick thought: Would it work for you to create a bunch of separate measures? So:
IF CONTAINS([Q7],"Heterosexual") THEN 1 else 0 END
IF CONTAINS([Q7],"Bisexual") THEN 1 else 0 END
Then when you put it in the view you can sum them.
Columns with a string of varying values are a tough nut to crack.
I wonder if Tableau would let you then pivot these calculated fields... You know on the data tab, if you're using Excel, you can select some columns, then right-click and choose pivot. Never tried to do it with a calculated field so I don't know if it would work.
This is what I ended up doing. Thanks for the note!