pivot table drop list
I have 2 pivot tables each with a page drop down list. My
goal is to have the 2nd pivot table update when the user
makes a selection from the first table's drop down.
Example: User selects "apples" from table 1 drop down.
Table 1 and table 2 displays data for "apples" as opposed
to user having to make 2 selection.
Make sense?
|