Nested Slicers loose the ability to reflect sub-group selection

[german_f2016]

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 between them (when the pivot table was present, the slicers showed the correspondent parent/child items in the other slicer). Is there a way to fix this? please advise.

[#2]

Well, I assume the slicers no longer affect the values calculated by the formulas. Do they?

[#3]

@Jan Karel Pieterse 

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. 

[#4]

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?

[#5 · Accepted solution]

@Jan Karel Pieterse 

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,