Adding drop down boxes to pivot chart

[jwpickett]

I've created a pivot chart but want to simplify it for the users.

We have 16 different districts, and within each district there are separate offices, all numbered numerically. I would like to be able to have a district manager choose his specific district and then choose a specific office (or all of his offices) and look at that data. I would also like to be able to have him choose the data he wishes to view, but this is of secondary importance.

While this can be done using normal drop down boxes on the Pivot Chart, you also have to scroll thru all the "district offices" to find the one you want. I would like to be able to limit each district to only have to select from their own offices. If they chose an office not in their district no data would be shown.

Is there any way to accomplish this? Im' thinking of an additional drop down box possibly separate from the Pivot Chart itself.

Thanks in advance.

 

[c_m_s_jr]

I created something similiar for a client. The issue you are having is that the pivot table drop downs will always show all options even if nothing exists after the first filter has been selected.

I used a drop down that fed an advance filter data set. This advance filter data set then created my pivot table so only the data related to the first item picked was listed. I can create a sample and send to you to look at if you wish.

 

[jwpickett]

I'd appreciate that to get an better idea of how to do it. Thanks

 

[c_m_s_jr]

Pm me your email...