I am trying to make a pivot table in Excel that shows me the results of a yes/no survey by location and date and I would like the option to get reults like "percent of yes" for the individual area and if possible a total like "23 results, 10 yes, 13 no, 43% yes".
I have played around with the percent options for the fields but I can't get what I am looking for and I am not sure it's possible but figured I would ask.
I have included an example sheet, in the pivot table I have included the percent of Yes is shown but it's a percent of total answers, I am looking to have the percent show a percent of yes for all records for that room. Which I know is compliated by the extra breakdown by dates but it's worth asking!
Slickdeals is able to share the best deals because of the contributions of users like you! If you found a great deal,
please share it with others by posting in our forums.
Welcome to Slickdeals!
Save money here by finding the lowest and cheapest price, best deals and bargains, and hot coupons. We're all about
community driven bargain hunting with thousands of free discounts, promo codes, reviews and price comparisons.
Don't worry, we'll help you find your way. If you haven't already, check out this
that explains the features of our site.