This is a follow-up to my earlier question. Thank you Eric Summers for addressing it.
This question is very similar.
I need help with the survey I'm working on.
I have data from 2 surveys, Survey A and B.
I am comparing results of each survey.
For each Question I would like to display [Survey Code] and [Measure %] with the highest SUM of "Definitely Purchase" + "Likely Purchase" answers
See screenshots below.
Thank you very much.
P.S. I have attached Excel spreadsheet I'm working with. I'm using Tableau Public.
It should look something like this
Retrieving data ...