Hi all.
I was wondering if it was possible to alter a Pivot Table based on a Slicer Selection. For instance, I have a pivot table broken out by region.
I would like a macro that would add a sub region if the West Region was selected, and City if the North region were selected, but if the North region was selected it would remove the subregion if that were already included from the previous selection.
I was wondering if it was possible to alter a Pivot Table based on a Slicer Selection. For instance, I have a pivot table broken out by region.
I would like a macro that would add a sub region if the West Region was selected, and City if the North region were selected, but if the North region was selected it would remove the subregion if that were already included from the previous selection.
