Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table active dropdown
I have a pivot table set up with 4 drop-down fields. Is it possible to set up
these fields so that the selection from the first drop-down restricts the choices available from the second? eg 1st field - Region North, South, East, West 2nd field - zone A,B,C,D,E,F,G,H,I... When Region South is selected, only those zones that are in the south are available to select from drop-down field 2? Help gratefully appreciated! :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table -- Refresh Data in Field Dropdown Lists | Excel Discussion (Misc queries) | |||
Duplicate values in Pivot table Page Field dropdown.. | Excel Worksheet Functions | |||
VBA to access Pivot Table Autofilter dropdown box | Excel Discussion (Misc queries) | |||
no show all function in dropdown list in Pivot Table | Excel Discussion (Misc queries) | |||
pivot dropdown list | Excel Worksheet Functions |