FlexPivotSlicer provides a header area with buttons to sort, multiselect and filter PivotGrid and PivotChart data. The slicer also shows a list of all unique values from the datasource.
The image below shows the appearance of FlexPivotSlicer.
The FlexPivotSlicer control consists of elements as follows:
-
Header: The Header area of the FlexPivotSlicer contains a Caption. It is same as the name of the field being filtered, in this case it is Country. Along with Caption, the header also displays Change sort direction, Multi-Select and Clear filter buttons on the right hand side. The FlexPivotSlicer control allows you to 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: Use the Change sort direction button to change 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 the ShowSort property of C1FlexPivotSlicer class.
- Multi-Select button: Use the Multi-Select button to change the selection mode for the list at runtime. Enable the Multi-Select button to select multiple items in the list. Note that enabling the Multi-Select button also 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 the ShowMultiSelect property of the C1FlexPivotSlicer class.
- Clear filter button: Use the Clear filter button to clear 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 the ShowClear property of the C1FlexPivotSlicer class.
- List: 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.