by contextures.com
When a pivot field is in the row or column area, you can sort the pivot items in that fields, using the built-in commands. For fields in the Report Filter area, there isn’t an easy way to sort the pivot items. I’ll show you how to sort manually, or use the pivot table report filter sort macro below to do the job quickly and easily
Continue reading “Pivot Table Report Filter Sort Macro Saves Time”
Why do new pivot items appear at the end of the lists, when you add them to an Excel pivot table? It’s hard to find those new items, if they aren’t sorted alphabetically. Keep reading, to see why that happens, and how you can fix the problem of new pivot items at end of list.
Top 10 Filters are a quick and easy way to focus on key items in a pivot table. Instead of looking at all the data, hide everything except a set number of top or bottom items.
In the screen shot below, you can see the Pivot Table Top 10 Filter dialog box. There are four drop down lists, where you can change the settings, but Excel won’t let you link to a worksheet cell, like it does in some dialog boxes.
Continue reading “Pivot Table Top 10 Filter From Worksheet Values”
After you set up a pivot table, you might like to prevent people from selecting items in one or more of the heading drop downs.
When you add new items to a pivot table, they might not appear in alphabetical order in the Report Filter drop down. This can make the items hard to find, if there is a long list.
In the drop down list below, Binder is a new product that was added to the source data. It appeared in the pivot table, after it was refreshed, but it’s at the bottom of the list, instead of the top.
Continue reading “Sort Items in Excel Pivot Table Report Filter”
When you create a pivot table, the items in each field are sorted alphabetically, in ascending order, like the products and cities shown below.
Instead of looking at all the data in a pivot table, you can use filters to narrow your focus. See how to apply one filter, or apply multiple filters on a pivot field, without clearing the other filters.
In the source data for your pivot table, you can use the drop down filters in the heading cells, to show only the records for a specific date range.
For example, in the table shown below, you could show just the orders that were shipped this week.
Continue reading “Dynamic Date Range Filters in Pivot Table”
When you add new items to a pivot table, they might not appear in alphabetical order. In the screen shot below, Binders is a new item, and it’s at the end of the list, instead of at the top.
Continue reading “Show New Pivot Table Items in Alphabetical Order”
If you frequently use filters in your pivot tables, here is a quick way to clear them. Thanks to AlexJ, who shared this tip. You can find more of AlexJ’s Excel sample files on my Contextures site.
