Excel; Pivot Table drop downs

[milton747]

Is there a way to re-populate a 2nd pivot drop down based on the choice made in a pivot drop down? (Page Level) eg: If I have USA, and Europe in drop down #1, I only want to show either US States or EU countries in the 2nd drop down?

Thanks

 

[SkipVought]

milton747,

This is an annoying shortcoming of Excel PivotTables. Bill Gates should fix that ASAP, in my book!

I use faq68-5829 to return a DISTINCT list based on some other selection.

Skip,

_[red][/red]

 

[milton747]

Hi Skip,

Thanks for the prompt reply.
I'm in sales presentation in Phoenix,AZ as I type.
The client asked and I wasn't sure.

Yeah, big hole. What a bummer.

Thanks again for reply.
Milton.