Define a summary with two Summary Fields: "count" with a calculation of Sum, and "count" with a calculation of Pct of Total.
Then define Product, Problem, and Sub Problem as your three Key Fields. While in the Summary Definition window, you can double click on each of these Key Fields and specify the following settings for each Key Field:
-- Matching tab: select "First 10 Values"
-- Sorting tab: select "Sort By Summary Field: count" and select Descending order
Click OK and you should have your Top 10 list.
If the resulting summary table is not quite what you have in mind, try this alternative approach: in the Table view, create just one new Calculated Field which concatenates together your Product, Problem, and Sub Problem fields into one field, ie:
Product" - "Problem" - "SubProblem
and use just this one combined field in your Summary, with the same above-mentioned Key Field settings and Summary Fields.
One benefit of the first approach is you use the can "drill up" and "drill down" Summary buttons to product top 10 lists by Product only, by Product and Problem only, as well as Product, Problem and Sub Problem.
[size="1"][ February 19, 2003, 12:21 PM: Message edited by: Mike Urbonas ][/size]