![]() To make multiple selection: press the CTRL key and select the names from the slicer list.ĩ. To analyze the performance of a sales person, select the name from the slicer.Ĩ. Tick all the check boxes and select OK.ħ. Note: Please download the workbookto practice this exerciseĤ. In our example, we are going to share the sales person’s slicer by linking it to the sales by branch and sales over time PivotCharts. You can save time by linking slicers to multiple PivotCharts, instead of inserting a separate slicer for each PivotChart.Īny changes that you make to a shared slicer is reflected immediately in all PivotCharts linked to the slicer. Slicers also indicate the current filtering state, which makes it easy to understand what exactly is shown in a filtered PivotTable report. By using slicers you can quickly drill down on a PivotTable. Slicers are used for filtering data and gives you a better understanding of your information.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |