Slicers

[rihabr]

Right now I have a slicer named "Clients" with options for Client 1 to 8. This is controlling a PowerPivot table. I was wondering if it would be possible to eliminate an option from the slicer. Essentially what I want is that Client 8 always remains chosen. I would only like the user to have the options of choosing Clients 1-7.

MORE IMPORTANTLY - I was also wondering if it would be possible to have a slicer which contained the option of showing/hiding calculated fields. I am trying to find an interactive way to make calculated fields appear/disappear instead of using the field list. Does anyone have any suggestions?

Any help would be really appreciated!

 

[SpillerBD]

I think you need to switch to Buttons calling your filter sets instead of using the slicers. Record as VBA each filter selection you want and associate with an appropriate Form Control (button). Don't forget a reset or ALL.