{"id":1491,"date":"2020-10-23T21:00:05","date_gmt":"2020-10-23T15:30:05","guid":{"rendered":"https:\/\/www.complianceprime.com\/blog\/?p=1491"},"modified":"2024-02-08T13:12:12","modified_gmt":"2024-02-08T07:42:12","slug":"how-to-filter-and-sort-the-data-in-a-pivot-table-in-excel","status":"publish","type":"post","link":"https:\/\/www.complianceprime.com\/blog\/2020\/10\/23\/how-to-filter-and-sort-the-data-in-a-pivot-table-in-excel\/","title":{"rendered":"How to Filter and Sort the Data in a Pivot Table in Excel"},"content":{"rendered":"

While creating a new pivot table in Excel, you will see that Excel automatically adds drop-down keys to the Report Filter field, along with the labels for the row and column fields. These drop-down buttons<\/span> in Excel are known as filter buttons, which enables you to filter all with specific entries in the field. The column and row fields sort the entries in the table.<\/span><\/p>\n

If more than one row or column field is added to the pivot table, then Excel adds collapse buttons that can be used to hide the subtotal values for a specific secondary field. After clicking on the collapse button in the table, it instantly becomes an expand button that can be clicked to redisplay the subtotals of that one secondary field.<\/span><\/p>\n

Filtering Pivot Tables in Excel\u00a0<\/span><\/h2>\n

In the Excel pivot table, the most significant filter buttons are added to the field\/fields named as the pivot table FILTERS. On selecting a specific option from the drop-down lists that are attached to one of the filter buttons, the summary data for that selected subset displays in the pivot table.<\/span><\/p>\n

For instance, in the Excel pivot table that plies the Gender field from the Worker Data file as the Report Filter field, one can present the sum of the women\u2019s or men\u2019s salaries by department and position in the pivot table by doing either of the following:<\/span><\/p>\n