How do I get a Pivot Table to *not* show me partial sums of row fields?

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!

pivot_table_sample.ods

Please edit your question to attach a sample file, but seems to me that you need to change columns by rows.

I have added a sample file thanks! Changing columns to rows doesn’t seem to help either - the questions are again broken up in the same way in the column headings.

Without change how the table it’s done, I don’t see how to do it. But preparing the table in other way then can be.

Attached a sample file Sample with modified table

Thanks so much for all the work! But I’m not sure this will help me much. For one thing this approach does not match the original data, in that in the table you made, it’s possible for a person to have answered “like roses” with both yes and no (which would be impossible in the original table). Also, I’d have to write a script to convert the original data - which incidentally is in the format that Google Forms and most other survey tools output their data - into this new format.

I think my question remains - is there no way to ask a Pivot Table to not provide partial sums for subsequent questions, and instead simply give each one its own row or column?