Pivot table filtering

It would be useful if I could use custom filters (the same as in Autofilter)
on pivot table Row/Column/Page fields rather than only being able to
select/deselect item by item.

My example was when using pivot tables for analysis on part-codes. I have
thousands of part codes and wanted to be able to filter the pivot table to
show only those containing "FG" in the number (finished goods) as there are
hundreds of these codes then selecting them line by line is not feasable.
Adding new columns to my data to work-round this is not the ideal way of
doing it (although it does work). I would like to be able to use data
extracted directly from my operational system rather than exported to excel &
manipulated, as this means the data is not always "live"

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

The next version of Excel will have label filters, as described here:

http://blogs.msdn.com/excel/archive/...20/506172.aspx

Lisa wrote:
> It would be useful if I could use custom filters (the same as in Autofilter)
> on pivot table Row/Column/Page fields rather than only being able to
> select/deselect item by item.
>
> My example was when using pivot tables for analysis on part-codes. I have
> thousands of part codes and wanted to be able to filter the pivot table to
> show only those containing "FG" in the number (finished goods) as there are
> hundreds of these codes then selecting them line by line is not feasable.
> Adding new columns to my data to work-round this is not the ideal way of
> doing it (although it does work). I would like to be able to use data
> extracted directly from my operational system rather than exported to excel &
> manipulated, as this means the data is not always "live"
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...lic.excel.misc


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html