J
joebogey
I'm not sure I'm calling this the right thing, or if it's even remotely
possible with PivotTables.
I have a list of data that consists of Work State, Work City, Job Title,
Salary Plan going from columns A-D. I have the PivotTable setup with the Work
State, Work City, and Job Title in the Page area and the Salary Plan in the
row area. Is there a way to make it so when a user Selects a Work State that
it will only show the City's for that Work State? Almost the way that
AutoFilter works but in a Pivot?
Thanks for any help.
possible with PivotTables.
I have a list of data that consists of Work State, Work City, Job Title,
Salary Plan going from columns A-D. I have the PivotTable setup with the Work
State, Work City, and Job Title in the Page area and the Salary Plan in the
row area. Is there a way to make it so when a user Selects a Work State that
it will only show the City's for that Work State? Almost the way that
AutoFilter works but in a Pivot?
Thanks for any help.