Separating out categories in an Excel Pivot table
Posted on 2016-08-17
I think what I want to do should be simple, but I can't quite figure it out.
I have a table of records with different values. eg.....
Gender Age Ethnicity
Male 60 British
Male 60 American
Female 40 British
All I want is the count of each category in the table
It's easy to use a Pivot table to get these results separately, But when I include multiple categories in the Pivot table they are always nested, so I can't easily see the individual values.
Hope this is clear. I am using Excel 2013 on Windows 7