FlexPivotSlicer provides a header area with a caption, buttons to sort, multiselect and filter PivotGrid and PivotChart data.

The following image shows the appearance of FlexPivotSlicer.

The FlexPivotSlicer control consists of elements as follows:

• Header: The Header area of the FlexPivotSlicer contains a Caption that is same as the name of the field being filtered, for instance, it is Country in the example showcased in the above image. Along with Caption, the header also displays Change sort direction, Multi-Select, and Clear filter buttons on the right hand side. You can toggle the visibility of the header area by using the ShowHeader property of the C1FlexPivotSlicer class.
  The purpose of all the header buttons is elaborated as given below:
  • Change sort direction button: Changes the sort order (ascending/descending) of the list items at runtime.
    Note that the Change sort direction button is not shown by default in the Slicer control, so you can display it on the Header with ShowSort property of the C1FlexPivotSlicer class. For more information on sorting, see Sorting.
  • Multi-Select button: Changes the selection mode for the list at runtime. Clicking the Multi-Select button allows you to select multiple items in the list and displays a Select All/Unselect All checkbox at the top of the list with which you can select or unselect all the items. You can toggle the visibility of the Multi-Select button in the header using ShowMultiSelect property of the C1FlexPivotSlicer class.
  • Clear filter button: Clears the filtering applied to the FlexPivotGrid or FlexPivotChart data at runtime. Note that the Clear filter button gets disabled if the Select All checkbox is active. You can toggle the visibility of the Clear filter button using ShowClear property of the C1FlexPivotSlicer class.
• CheckList Area: Once the FlexPivotSlicer is bound to a field, the list area of the control shows a list of all unique values from that field. FlexPivotGrid or FlexPivotChart data can be filtered based on the values selected in this list.