I'd like to create a stacked chart using multiple measures. Outline shown below but essentially the requirement is to see the count of the number of times a comment was made against a particular category and then stack the bar by how often, as a percentage, was that comment agreed with. I've attached an excel showing some example data of:
79 Observations made against 6 categories.
Votes for Agree, Disagree or Neutral against observation,
Totals for the votes in each Agree, Disagree, Neutral preference
% of votes for each preference (Agree etc) against each category.
Any help appreciated!