• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Capturing Multiple Slicer Items

D

Debbie Clifford

New Member
I do not have PowerPivot loaded and that may be the only answer here, but I'll try any way. How would I capture the items selected from multiple slicers? I have 4 slicers on my pivot table. When one or more items is selected in one of the slicers, the other options in the slicers are selected that match that choic. For instance. I have a list of programs. If I select the Program Manager in the slicer, the Analyst name will be highlighted in the Analyst slicer and the Program Phase will be highlighted in the Phase slicer. How would I present in a vertical or horizontal fashion the slicer items highlighted? I can capture the actual item selected by using the slicer as a filter in the pivot and just using =B3; however, all the other slicers will show "All Items" even though they are now filtered by the matching item selected in the first slicer. So what I am after as a result would be: PM: Debbie Baker, Analyst: Sharon Hill, Phase: 0. Thanks for any help that may be provided. I've gone over CUBESET and CUBERANKEDMEMBER but I believe that only works with PowerPivot
 
You are right. CUBESET/CUBEMEMBER only works with OLAP based PivotTables.

One way to do it is to iterate through SlicerItem for each Slicer and read .Selected Property. If True then return .Value property of SlicerItem.

I'd recommend uploading sample workbook to get more detailed help.
 
You must log in or register to reply here.
Back
Top