How to Use the Excel 2013 Quick Analysis Tool
Create a Histogram with a Pivot Table for Excel Dashboards
How to Format Values in the Pivot Table in Excel 2013

How to Filter a Pivot Table Report in Excel 2013

In Excel 2013, perhaps the most important filter buttons in a pivot table are the ones added to the field(s) designated as the pivot table FILTERS. By selecting a particular option on the drop-down lists attached to one of these filter buttons, only the summary data for that subset you select displays in the pivot table.

For example, in the sample pivot table that uses the Gender field from the Employee Data list as the Report Filter field, you can display the sum of just the men’s or women’s salaries by department and location in the body of the pivot table doing either of the following:

  • Click the Gender field’s filter button and then click M on the drop-down list before you click OK to see only the totals of the men’s salaries by department.

  • Click the Gender field’s filter button and then click F on the drop-down list before you click OK to see only the totals of the women’s salaries by department.

When you later want to redisplay the summary of the salaries for all the employees, you then re-select the (All) option on the Gender field’s drop-down filter list before you click OK.

When you filter the Gender Report Filter field in this manner, Excel then displays M or F in the Gender Report Filter field instead of the default (All). The program also replaces the standard drop-down button with a cone-shaped filter icon, indicating that the field is filtered and showing only some of the values in the data source.

blog comments powered by Disqus
How to Move Pivot Charts in Excel 2013
How to Add Calculated Fields to Pivot Tables in Excel 2013
How to Move Pivot Charts to Separate Sheets in Excel 2013
How to Create a Pivot Table with the Excel 2013’s Quick Analysis Tool
Use Excel Pivot Tables to Get Top and Bottom Views
Advertisement

Inside Dummies.com