I have this pivot chart (please see attached screenshot) that I was hoping to use to display results of a survey that was conducted by our nonprofit organization. I have it filtering by a few demographics (age, gender, parental status), and then the results of a few other questions below it. My problem is that I'm not sure what results I'm looking at -- whether they're totals of all the responses, just the "true" responses, or...?

The survey asked questions similar to what you see in the field list. Each question is a column header in my table. Then the row headers are each respondent. The choices for answers were "true", "false", or nothing. So in all the cells, i entered t, f, or nothing accordingly.

I'm not sure if I'm not using the pivot chart correctly, or if I didn't design the table for the data correctly.

OK I think I figured out what was wrong! I had the initial table setup wrong for data entry. Originally, I was entering "y" for Yes and "n" for No. This time, I started from scratch, went to the table in design view, used the Lookup Wizard to create a drop-down box containing True, False, and Blank for the cells in the table. Now when I switch to PivotTable view and drag/drop my fields, it automatically counts the answers. Yeah!