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! :)