Top/Bottom: In this case since we are looking for top retailers that make 25% of the total sales, select Top.Let’s say you want to get the list of retailers that make up 25% of the total sales. You can use the top 10 filter to get a list of top 10 percent (or any other number, say 20 percent, 50 percent, etc.) of items by value. Filter Top/Bottom Items that make up a Specified Percent of the Value You can use the same process to get the bottom 10 (or any other number) items by value. This will give you a filtered list of 10 retailers based on their sales value. In this case, since we only have the sum of sales, it shows ‘Sum of Sales’ only. The last field lists all the different values listed in the value area.In this case, since we want the top 10 retailers, select Items. The third field is a drop down with three options: Items, Percent, and Sum.In this case since we want to get top 10 items, this would be 10. The Number of items you want to filter.Top/Bottom: In this case since we are looking for top 10 retailers, select Top.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. Let’s see how to use the Top 10 filter with this data set. Suppose you have a Pivot Table as shown below: 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: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |