Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table single choice
Good morning!
I am fairly new with pivot tables....so I appreciate any advice. I have a large spreadsheet that lists material part numbers, how many are expexted and when they are due. I have my pivot table set up to show part numbers on the left, date to be received on the top, and quantity due in the center. This works very well to show all the part numbers. The user has a need, once they have this pivot table to narrow to 1 or 2 part numbers. if you click on the filter arrow of the part number, all 600 part number boxes are checked. Is there a way to uncheck them all except 1 or 2 without manually unchecking them all? Is there a better way to do this? Thanks again for any thoughts. Have a GREAT day! brenda |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table single choice
In Excel 2000, and earlier versions, where the Show All checkbox isn't
available, you can use programming to hide or show the items. There's sample code he http://www.contextures.com/xlPivot03.html frendabrenda1 wrote: Good morning! I am fairly new with pivot tables....so I appreciate any advice. I have a large spreadsheet that lists material part numbers, how many are expexted and when they are due. I have my pivot table set up to show part numbers on the left, date to be received on the top, and quantity due in the center. This works very well to show all the part numbers. The user has a need, once they have this pivot table to narrow to 1 or 2 part numbers. if you click on the filter arrow of the part number, all 600 part number boxes are checked. Is there a way to uncheck them all except 1 or 2 without manually unchecking them all? Is there a better way to do this? Thanks again for any thoughts. Have a GREAT day! brenda -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table single choice
For the ability to select single items in your table 'drag' your part number
field to the 'Page' area of the pivot table. -- T Tipsy "Debra Dalgleish" wrote: In Excel 2000, and earlier versions, where the Show All checkbox isn't available, you can use programming to hide or show the items. There's sample code he http://www.contextures.com/xlPivot03.html frendabrenda1 wrote: Good morning! I am fairly new with pivot tables....so I appreciate any advice. I have a large spreadsheet that lists material part numbers, how many are expexted and when they are due. I have my pivot table set up to show part numbers on the left, date to be received on the top, and quantity due in the center. This works very well to show all the part numbers. The user has a need, once they have this pivot table to narrow to 1 or 2 part numbers. if you click on the filter arrow of the part number, all 600 part number boxes are checked. Is there a way to uncheck them all except 1 or 2 without manually unchecking them all? Is there a better way to do this? Thanks again for any thoughts. Have a GREAT day! brenda -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table layout | Excel Discussion (Misc queries) | |||
Linking to a pivot table from a formatted invoice | Links and Linking in Excel | |||
pivot table mutliple choice in page section | Excel Discussion (Misc queries) | |||
pivot table - New Data | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) |