Pivot Table Grouping / Nesting Question

[jackbergersen]

I am having an issue with getting a Pivot Table to display data how I would like to report on it. The column labels are fine, and when I put one field into the row label section, I see data how I would like to. When I add another field to the Row Label section, it nests this within the first question, where I really just want to keep them grouped seperately by field and display in one table. I think the graphics below will help explain this better.


Pivot Table with 1 field for the row & column sections, which is fine:

When I add the second field in, the fields 'nest', whereas I would like them to 'group':

Ideally, I would like them to stay grouped by each field, similiar to below (This is all hardcoded, I just wanted to show my ideal output):

I have been banging my head against this for hours now, and would really appreciate any help. Thanks!

 

[DonkeyOte]

I think you've posted this question on other forums also (please detail accordingly).

Based on your screenshots - you would need to redesign the layout of your source data.

"Questions" would be the heading with appropriate value stored on a transaction level basis.
Responses & Breed would be the other transaction level values.

Question | Response | Breed
Q1 Product Detail | Both | Dog
Q8 code responses | Other | Multi
Q8 code responses | Other | Multi
Q1 Product Detail | Consumables | Cat
etc...

From the above source data you could then set Question & Response as Row Fields with Breed as Column Field and Data Field (set to COUNT).

(it's not clear how Breed is presently recorded - implication being it's related to Q1 specifically whereas in reality you should replicate for each Q given your proposed final PT layout....)

 

[jackbergersen]

Thanks for the reply! Yes, I did post on one other message board (apologies if this is against the T&C of either site).

I think I am a bit confused by your proposed solution, the source data is currently laid out as transactional data (survey results), and is formatted like the following example:

Thanks again!