Using XP and Office 2003

Column A has a list of budget categories like "Administration" and "Payroll"
and "Building Maintenance."

Column B has the specific line item account breakdowns within each category.

Column C has the actual expenditure amount in dollars and cents.

I selected my column titles and applied the Auto Filter.  I can filter by
Column C to show the top 10 line items (those items on which we spent the
most money.)

When I filter Column A to just show me the Administration category, then try
to apply the filter to Column C to show the top 10 line items within the
budget category, it doesn't seem to work.  It seems to give me only the line
items from the Administration category that are in the overall top 10.

Is there a way to show all of the top ten items within the individual budget
categories??