Okay, have a pivot table for assignments
doing grad research, sent out preliminary questionnaires.
for all rows in source data, the last column is never blank so I've have it in the pivot table as count data as a total of questionnaires received from various sources/experiment groups
then I have the questions as data. ie "Do you like pepsi?" with that expressed as count data (number of ppl who ticked either yes or no)
What I want to do is express column 1 (question) as a percentage of the count data in the last column (this would be percentage of ppl who did not leave question blank, or technically
any suggestions?column one = # of non-blank responses for question/# of questionnaries received
Bookmarks