Preventing Nested Grouping When Adding Rows to Pivot Table in Excel
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...
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?
2 Answers
This one might be helpful Check it out:
You need to change both of these settings:
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.
Sophia analyzes international trade, startup ecosystems, retail transformation, and supply chain logistics for modern digital publications.
