Pivot Chart: Can Page Fields Interact?

[billcockerill]

Dear Forum,

I have a pivot chart with two page fields across the top, County an
City.

I would like it so that when I select a County, only the Cities in tha
County will appear in the City page field to be selected.

Can this be done in a pivot chart?

Is there a VB solution.

Thanks, Bill Cockeril

 

[dave]

-----Original Message-----
Dear Forum,

I have a pivot chart with two page fields across the top, County and
City.

I would like it so that when I select a County, only the Cities in that
County will appear in the City page field to be selected.

Can this be done in a pivot chart?

Is there a VB solution.

Thanks, Bill Cockerill

 

[dave]

i dont know if this will work for you, but if you move the
city page field and make it the left column of the pivot
chart, you would accomplish the task. Only the citieis in
the selected county would show up in the pivot table.

I dont think they can interact otherwise.