I am now using pivot tables with data from an oracle database. I've learned how to create a pivot table, but I would like to flatten out the results. What I mean is if I pick several fields for columns the counts are broken down by each field until the last is a total. I would like to have several columns like Gender, Age, Race and have each of these columns be a total count of the data and not a stepped count where each column is repeated for each item of the previous column. So for Gender there would be M and F columns and the numbers in those columns would represent the total for that row. The same for Age and Race. so the table would look more like this:

                         Gender                     Age                                 Race

                        F          M            <25        25+             Ethnic         Non-Ethnic

January            8           6               4           10                  9                  5

Can you do this with a pivot table? Should I be using something else?

The oracle database has too much data to pull into excel. I just want to have the results there. The pivot table allows me to filter and accum totals, but not the way I have shown above. It always creates a hierarchy with the column fields.

I am using excel 2010.

Thanks for your help.

You need to create three separate pivot tables based on the same data.

I guess so, too. You could probably also use a slicer to connect all of the 3 tables, so you don't have to select January 3 times.