If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
pivot table created from another pivot table | Kreed | Worksheet Functions | 6 | October 26th, 2005 04:16 PM |
Add New Field to DB | Karen | Database Design | 7 | October 19th, 2005 08:03 PM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |