Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table filtering
The next version of Excel will have label filters, as described he
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional if or filtering in pivot table | Excel Worksheet Functions | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Filtering data from one pivot table against another | Excel Discussion (Misc queries) |