xlSlicerCrossFilterType

Specifies the type of cross filtering used by the specified slicer cache and how it is visualized.

xlSlicerNoCrossFilterCross filtering is turned off entirely, so all tiles are displayed and active (not dimmed) regardless of filtering selections in other slicers (1)
xlSlicerCrossFilterHideButtonsWithNoData(Added in 2013) Cross filtering is turned on for this slicer cache, any tile with no data for filtering selection is other slicers connected to the same data source will be dimmed
Additionally buttons will be hidden (4)
xlSlicerCrossFilterShowItemsWithDataAtTop(Default) Cross filtering is turned on for this slicer cache, any tile with no data for a filtering selection in other slicers connected to the same data source will be dimmed
Additionally, tiles with data are moved to the top in the slicer (2)
xlSlicerCrossFilterShowItemsWithNoDataCross filtering is turned on for this slicer cache, any tile with no data for a filtering selection in other slicers connected to the same data source will be dimmed (3)

xlSlicerNoCrossFilter
Cross filtering is turned off entirely, so all tiles are displayed and active (not dimmed) regardless of filtering selections in other slicers (1)
xlSlicerCrossFilterHideButtonsWithNoData
(Added in 2013) Cross filtering is turned on for this slicer cache, any tile with no data for filtering selection is other slicers connected to the same data source will be dimmed
Additionally buttons will be hidden (4)
xlSlicerCrossFilterShowItemsWithDataAtTop
(Default) Cross filtering is turned on for this slicer cache, any tile with no data for a filtering selection in other slicers connected to the same data source will be dimmed
Additionally, tiles with data are moved to the top in the slicer (2)
xlSlicerCrossFilterShowItemsWithNoData
Cross filtering is turned on for this slicer cache, any tile with no data for a filtering selection in other slicers connected to the same data source will be dimmed (3)

REMARKS
* Added in 2010.

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top