Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if there an option allow me to appear the item in pivot table as .
as the auto filter when you select any item appears only the related data to
it so the range of choice will be less, i ask for an option in the pivot table do the same to be more easy to choice from less choices don't choose from all items in the data base ,only from the items which related to my choose. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
if there an option allow me to appear the item in pivot tableas .
There's no option in the pivot table that will create dependent dropdown
lists in the page fields. Hossam wrote: as the auto filter when you select any item appears only the related data to it so the range of choice will be less, i ask for an option in the pivot table do the same to be more easy to choice from less choices don't choose from all items in the data base ,only from the items which related to my choose. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PIVOT TABLE - hiding records with CALCULATED item values equal to | Excel Discussion (Misc queries) | |||
Delete item from Pivot Table field? | Charts and Charting in Excel | |||
pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
Pivot Table Grand Total - Calc Item | Excel Worksheet Functions | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) |