I have created a PowerPivot 2013 PivotTable in Excel due to the need to calculate distinct values for numerous calculations that cannot be efficiently calculated using array formulas. So I will not be able to use the normal Excel Pivot Table features.
I am using:
3 columns in a table for the Row Labels (Cohort Year, Gender, Ethnicity)
1 column in the table for the Column Labels (Major_1)
This seems like it should be simple, but I can't find out how anywhere?
I would like to see the rows group together and nest both gender and ethnicity into the year, but not into each other...as follows:
However, the Pivot Table insists on nesting the Ethnicity inside of the Gender or vice versa. It simply will not separate them out into separate categories. This is what it look like now:
Not Hispanic/Latino (Females)
Not Hispanic/Latino (Males)
Many thanks in advance for your help.