![]() ![]() PivotTable with summarized values for the selected items will be displayed. Selected items in the Slicers are highlighted. Keep Ctrl key pressed and click on March in the Slicer for Month. Keep Ctrl key pressed and click on West in the Slicer for Region.Ĭlick on February in the Slicer for Month. Only South will be highlighted in the Slicer – Region. Suppose you want to display the PivotTable only for the regions South and West and for the Months February and March.Ĭlick on South in the Slicer for Region. By default, all the values of a field are selected and hence all the buttons are highlighted. Filtering with SlicersĪs you can observe, each slicer has all the values of the field that it represents and the values are displayed as buttons. Slicer Tools appear on the Ribbon to work on the Slicer settings, look and feel. Slicers for each of the selected fields appear with all the values selected by default. It contains all the fields from your data table. Suppose you want to filter this PivotTable based on the fields – Region and Month.Ĭlick on ANALYZE under PIVOTTABLE TOOLS on the Ribbon.Ĭlick on Insert Slicer in the Filter group. ![]() Assume you have the following PivotTable with this data. To understand the usage of slicers, consider the example of sales data region-wise, month wise and salesperson-wise. ![]() Slicers stay visible with the PivotTable and so you will always know what fields are used for filtering and what values in those fields are shown or hidden in the filtered PivotTable. You can click on the buttons of a slicer to select/ unselect the values in the field. Slicer will have buttons denoting the values of the field that it represents. Slicers can be inserted for each of the fields that you want to filter. Using one or more slicers is a quick and effective way to filter your data. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |