In the Top 10 Filter dialog box, there are four options that you need to specify:.Go to Row Label filter –> Value Filters –> Top 10.You can use the Top 10 filter to get a list of top 10 retailers based on the sales value.
#EXCEL PIVOT CHART CHART FILTER HOW TO#
Let’s see how to use the Top 10 filter with this data set. Suppose you have a Pivot Table as shown below:
![excel pivot chart chart filter excel pivot chart chart filter](https://infoinspired.com/wp-content/uploads/2019/09/Excel-Value-Filter-5919.jpg)
![excel pivot chart chart filter excel pivot chart chart filter](https://i.stack.imgur.com/BIFXp.jpg)
Filter top/bottom Items that make up a Specified Value.Filter top/bottom items that make up a Specified Percent of the Values.You can use the top 10 filter option in a Pivot Table to: Filter Top 10 Items by Value/Percent/Sum.The following examples are covered in this section: Let’s see some practical examples of how to use these to filter data in a Pivot Table. Note, there are two more filtering tools available to a user: Slicers and Timelines (which are not covered in this tutorial). Alternatively, you can also selectively exclude some retailers by unchecking it. For example, if you want to hand pick retailers to analyze, you can do this here. Check Boxes: These allow you to select specific items from a list.For example, if you want data for Costco only, just type Costco here and it will filter that for you. Search Box: You can access this filter within the row/column label filter and this allows you to quickly filter based on the text you enter.Row/Column Label Filter: These filters allow you to filter relevant data based on the field items (such as filter specific item or item that contains a specific text) or the values (such as filter top 10 items by value or items with a value greater than/less than a specified value).You create this filter by dragging and dropping the Pivot Table field into the Filters area. For example, if you have retail sales data, you can analyze data for each region by selecting one or more than regions (yes, it allows multiple selections as well). Report Filter: This filter allows you to drill down into a subset of the overall dataset.Here is a demo of the types of filters available in a Pivot Table. Filter Top/Bottom Items that make up a Specified Value.Filter Top/Bottom Items that make up a Specified Percent of the Value.Examples of Using Filters in Pivot Table.