software

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 quot;FGquot; 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 amp;
manipulated, as this means the data is not always quot;livequot;

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; 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 quot;I Agreequot; in the message pane.

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

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

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

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