FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Slicers are basically just filters but are easier and faster to use, allowing you to instantly pivot your data. If you frequently filter your PivotTables, you may want to consider using slicers instead of filters.

Detailed explanation-2: -Click anywhere in the PivotTable to show the PivotTable tabs on the ribbon. On the PivotTable Analyze tab, click Options. In the PivotTable Options dialog box, click the Totals & Filters tab. In the Filters area, check or uncheck the Allow multiple filters per field box depending on what you need.

Detailed explanation-3: -Just like filters, only selected items are used in the PivotTable. When you select or deselect an item, the PivotTable will instantly reflect the change. Try selecting different items to see how they affect the PivotTable. Press and hold the Ctrl key on your keyboard to select multiple items at once.