Forum Discussion
Solved
Nested Slicers loose the ability to reflect sub-group selection
When working properly and when not working properly: I had my pivot table converted to formulas using the OLAP tools and now the slicers seem to work, but don't communicate betwee...
Thank you,
Jan, having the pivot table back in a single cell connected to the slicers did the trick! The visual aid is working now.
Regards,
Well, I assume the slicers no longer affect the values calculated by the formulas. Do they?
Hi Jan,
Actually, they work fine. The problem is that the two slicers do not give a visual clue of what is being selected in the other slicer. Before the conversion to formulas, when you selected one element in the right-side slicer, the left-side slicer dimmed out the boxes not related to the selection.
- Perhaps you could add the pivot table back again, but with only a total row (so just a sum field and no row or column or page filters). Tie that toe the slicer and it should work again?
Thank you,
Jan, having the pivot table back in a single cell connected to the slicers did the trick! The visual aid is working now.
Regards,