I am building a model where when regions will be selected via a filter in a slicer but need it to change which field is brought in depending on which region is selected. In other words, I want the slicer to stay so that you can easily select the region, but I need the column headers in the pivot to change when the region does. So when "Region B" is selected in the filter, "Region B Grouping" shows up in the columns instead of "Region A Grouping" since it would be a pain (and easy for other people looking at the model to make a mistake) to have to change what goes in the column each time. Is this possible?
Changing Columns/Series in Pivot Tables when Filter is changed
- Thread starter mdp22
- Start date
- Joined
- Dec 16, 2012
- Messages
- 2,319
- Reaction score
- 40
- Points
- 48
- Excel Version(s)
- 365
Very probably.
To stop us guessing wrongly all sorts of things about your setup, post a workbook (desensitised/sanitised) with such a pivot table in.