Auto Filter Top 10

[BK]

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??

 

[Jim Rech]

The top 10 filter is without regard to any other fields. I think you'll
have to copy the list after filtering by column A and do a top 10 on it.

--
Jim
| 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??
|
|

 

[Debra Dalgleish]

Another option would be to create a pivot table from your list. Put the
Budget Category field in the Page area, Line Item in the Row area, and
Expenditure in the Data area.
Then, double-click on the Line Item field button
Click the Advanced button, and set Top 10 Autoshow to On.
Select a Budget Category from the page field dropdown list, to see the
top items for that category.

There are instructions here for getting started:
http://www.contextures.com/xlPivot01.html

 

[BK]

Thanks for the response. We have lots of pivot tables already on this
data, so maybe I can make it work on one of those.

 

[BK]

That's what I figured!! Thanks!!