Thanks for your help.

"Debra Dalgleish" wrote:

No, the dropdown lists in the pivot table fields aren't dependent on the
selections in another field. There isn't a setting that will let you
change this behaviour.