Slicers and Calculated Items in Pivot Table

[League]

I have a Pivot Table/Pivot Chart with slicers. There are 4 slicer
attached. When one slicer is filtered the other slicers will filter(gre
out) accordingly. But I also have some calculated items in Column Labe
field. When 1 of these calculated items is selected, the slicers al
lose their filter link to each other. (unavailable items in othe
slicers are no longer greyed out) Non-calculated items don't affect th
slicers this way.

Once the slicers are unlinked I can't get them to link with each othe
again.(I have to open an earlier copy)
All the slicer fields are in the Report Filter section of pivot and dat
is too large to move these fields to row labels section of pivot.
Pivot source is a MS query connection to an Access database.
Calculated Items are ratios and are calculated to the desired level b
the use of the Report Filters.

This workkbook will be used by management so I need an easy way t
select only items that are still 'available' after 1 or more of th
Report Filters is used. Slicers looked like the answer but an
suggestions would be helpful

 

[League]

Once the slicers are unlinked I can't get them to link with each othe
again.(I have to open an earlier copy)

Slicers do relink when calculated items are filtered out

 

[League]

I figured out a workaround for my issue.

My calculated items are ratios and I need the ability to roll up t
different levels so I created a second pivot table with just my slice
fields as report filters and attached slicers. The fields are als
Report Filters in the first pivot. Got the idea from thi
site:http://tinyurl.com/opztr5x Slicers are not attached to first pivot
Then I run a macro that updates the first pivot Report Filters wit
values from the second pivot. User selects wanted values in the slicer
then clicks button to run macro. I only want "all" or one value at
time in each slicer so this works for me. Not as elegant as I would lik
but it works