VBA Slicers - select multiple items

[Jonstrup]

Hi all

Ok, this is doing my head in. Have been searching hi and low and I simply can't find the solution.

In excel 2010 i have a pivot table named Count1.

I have a set of slicers named Shift_types with about ten different items named randomly like "ShiftA", "DayOff", "Night", "Day", "WKND 6. week" etc.

What I am after is a via that can select pair and groups. For instance ShiftA and Night should be visible at the same time.

I would also want to combine DayOff with Night and "WKND 6. week".

Hop some one can help.

Thank you.

br
Kasper

 

[Jerry Sullivan]

Hi Kasper,

I presume you know how to do this manually and are looking for an automated way to select saved combinations of items.

Just in case, I'll note that you can select multiple items from a slicer manually by holding down the Ctrl key. (Or Shift to select consecutive items).

I'm not aware of any built-in way to select saved pairs and groups. Potential workarounds include:

1. Adding another field that identifies these groups, then using a slicer for that field.
2. Using VBA to filter specified lists of PivotItems

 

[Jonstrup]

Hi Jerry

Thank you very much for the reply.

But yes, I am aware of how to do it manualy and this i for an automated version.

Even though I knew about the ctrl option to choose more than one slicer perhaps some one else can stumble across it and find it useful for their purpose.

br

 

[Jerry Sullivan]

Okay. If you want help with one of those two workarounds, please let me know which one you want to pursue.