By reshaping the data, the desired output can be created. I have attached an Excel sheet--refer to Sheet1-Tableau. The following links provide the reshaper tool and information on how to form data:
Hope this helps!
delete.xlsx 9.7 KB
Thanks Tracy. This will solve the problem with one or two questions. However, I have more than 30 questions and I cannot reshape the data, that will be too complex. This is a very easy cross table in SPSS or JMP. Any way to get around in Tabelau?