The spinning 'thinking' icon comes up for a moment, but the Slicer never appears. In the Filters group, click the Slicer command. Then you right click on the field (s) you have chosen and click on Add as Slicer. Thank you very much in advance for any help.

This is a good way to break out each region into its own chart. On the PivotTable Analyze tab, in the Filter group, click Insert Slicer. A third alternative could be that the slicers can be placed on another worksheet and whatever selections will be made in the slicers, only those will appear on the Pivot Table.This is a more powerful feature than f You need to first add your three tables to the Data Model. So: Worksheet 1: 2 slicers Worksheet 2: 1 pivottable connected to slicer 1 Worksheet 3: 1 pivottable connected to slicer 1 Worksheet 4: 1 pivottable connected to slicer 1 Worksheet 5: 1 pivottable connected to slicer 2 Worksheet 6: 1 pivottable connected to slicer 2 Apologies, but something went wrong on our end. Excel Yourself: Slicers in Microsoft Excel. Spacebar will toggle the Multi-Select state. Press Tab again to move into the slicer, first to the Multi-Select icon added in Excel 2016. This webinar will show you how to take large amounts of data from many sources and processes into great reports. Any fixes or alternative possible solutions.

How to make pivot table in mac numbers