Excel 2007 : Pivot Table to create Drilldown of Facets?

I am trying to take an excel sheet of faceted navigation used on a website and create a drill-down with a pivot table to see which combination of facets are used most frequently. For example:

Instances Criteria Criteria Criteria Criteria
1000 Make Model
900 Make Model StartYear EndYear
800 Make End Year


I would like a pivot table view where I can drill in like this (Example for just drilling down "Make" and expanding all levels):

Make 2700
--Model 1900
----StartYear 900
------EndYear 900
----EndYear 900
--Start year 900
----EndYear 900
--End Year 1700
----Model 900
----StartYear 800


I cannot seem to combine the Criteria fields, instead the Pivottable autonumbers them as Criteria1, Critera2, etc. This doesn't work because it won't aggregate common field values across those different field names.

Can this even be done with Excel? If not does anyone have any other ideas?

Just renaming the columns in my first example won't really work because the criteria values could be listed in any column, the pivot table treats each column independently and won't aggregate the values across fields.

Do you mean something like this?


Case # Make Model StartYear EndYear
1 1000 1000
2 900 900 900 900
3 800 800

I don't see how that will work either.