Thanks for this brilliant piece of software!
I’m trying to figure out how to use Pivot Tables in Calc for survey data. I have data from two different survey locations, and in each location there were a number of questions asked. Let’s say question 1 is “Do you like the colour red?” and question 2 is “Do you like cake?” Both are yes/no questions. The sheet with the data records where each person was surveyed (location A or Location B), and then their answer to each question (Yes or No). Each question is its own column.
I want to get a pivot table where I have only four columns - the question asked, Location A, Location B, and totals. Then I’d like to get rows for each question, divided into one subrow for the ‘Yes’ answers and one for the ‘No’ answers. In order to do this, I’m putting “Survey Location” in the ‘Column Fields’ after ‘Data’, and putting Question 1 and Question 2 into the Row fields (in that order) and into the Data Fields (also in that order). I set both Question 1 and Question 2 to give me Count (not Sum).
This is almost what I want - but there is one major headache. When I do this, Question 1 and Question 2 appear as columns next to each other, and I get the counts for Question 2 divided up by the counts for Question 1. I.e. I get the breakup for how many people who answered Question 1 with yes then answered Question 2 with yes and no, and then the breakup for how many people who answered Question 1 with no answered Question 2 with yes and no. From the documentation I understand this is called a ‘partial sum.’
Edit: Have attached a sample file that shows what I need, on the second sheet.
This is useless to me, as Questions 1 and 2 are independent of each other. I just want Question 1 first and then Question 2 second and so on. Is there any way to generate a Pivot Table like this?
Thanks so much in advance!