![]() ![]() Gotcha: If there is a tie for fifth place, the list may contain more than five customers. You can hover over this icon to see a list of the filters applied Note that a Filter icon appears in cell A3 to indicate that you are not seeing all customers. Results: The report will be filtered to show just the top five customers. ![]() The pivot table shows the top five customers.The third field offers Items, Percent, and Sum. You can use the spin button to change 10 to any other number. The first dropdown offers to filter to the top or bottom customers. Although it is called the "Top 10" feature, it is far more flexible than that. By default, the dialog wants to show the top 10 items based on Sum of Revenue. The top 10 can do to or bottom, 5, 10, 20, and more.Įxcel displays the Top 10 Filter (Customer) dialog.Open the dropdown at the top of the customer dropdown.Build a pivot table with Customers in the row area.Strategy: You can accommodate this vice president by using the Top 10 Filter feature that is available in pivot tables. He wants to see only the top 10 or 20 or 5 customers each month. If I'm preparing a report for the senior vice president of sales, he may not care about the 400 customers who bought spare batteries this month. Problem: Many times my customer reports have hundreds of customers. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |