This new pivot table will display a list of the items that are filtered for in the first pivot table. If not, right-click the slicer > Report/Pivot Table Connections, and check the boxes for both pivot tables on this sheet.
We can check the Select Multiple Items box in the filter drop down menu to filter the pivot table for multiple items in the field. This is a great way to filter the report to only see data for certain time periods, categories, regions, etc. The Filters area of the pivot table allows us to apply a filter to the entire pivot table.
#Excel for mac pivot chart filter download#
We’ll look at Slicers in an upcoming Download The (Multiple Items) Dilemma Note that slicers are another way to filter an entire pivot table. This will clear all report filters, and any other filters in the pivot table.
If you want to clear all filters from a pivot table at once, you can use the clear menu, on the Options tab on the PivotTable Tools ribbon. For example, we can add the Category field to the report filter, and then filter to show only Products in the Exotic category in the West region. You can add more than one field to the report filter at the same time. If we drag Region back into the Report Filter area, we see it is still filtering to show only the Midwest and South regions. Report filters maintain a “memory” of their last configuration. You can select All in the menu, or, if we undo that, you can also just drag the Region field out of the Report Filter area. To clear the report filter, you have two options. For example, we can show sales for the Midwest and South. The “Select Multiple Items” setting, allows you to select more than one item at a time. If we select East, we see sales for Cities in the East. When we select West, we see only sales for cities in the West region. If we click the arrow next to the report filter, we see a drop-down menu that shows all items that appear in the Region field. If we now add the field Region as a report filter, we’ll gain the ability to filter the report globally by region.īy default, a new report filter shows all items.
If we add the City field as a Column Label, we see a breakdown of sales by city in each column. However, the report filter gives you a way to quickly limit the information that appears in the table by filtering on one or more fields.įor example, this pivot table shows Total Sales by product. There are many ways to filter information in a pivot table, but the report filter is the most basic tool to limit information in a pivot table globally.īy default, a new pivot table will summarize all of the source data.