excelpivot-table

Preventing nested grouping when adding rows to pivot table in Excel


enter image description here

With the picture above in mind, I am trying to form pivots for each different age category and gender, using Excel 2016. Currently, however, when I add age and gender to the row category of pivot tables, it forms a nested group by.

Instead, I need to have un-nested/distinct pivots for the genders and age categories.

Is there anyway to achieve this in Excel?


Solution

  • You can write code to create multiple copies of your pivot table, or just copy and paste manually, but you can't make a pivot table not group nested fields. That's the entire point of a pivot table, after all.