From the course: Excel: PivotTable Tips
Unlock this course with a free trial
Join today to access over 22,600 courses taught by industry experts.
Enabling multiple filters - Microsoft Excel Tutorial
From the course: Excel: PivotTable Tips
Enabling multiple filters
- [Instructor] All right, time to share one of my favorite Pivot Table pro tips, applying multiple filters to a single Pivot Table field. Now, by default, you can either apply label filters, which are based on text, or value filters, which are based on numbers, to a single given field in a Pivot Table, but not both at the same time. So, in other words, if you had a label filter applied, and then added a value filter, that new value filter would overwrite or wipe out the existing label filter. So to change this, what we're going to do is head to our Pivot Table Options, we're going to drill into our Totals and Filters tab and check this box that says, allow multiple filters per field. Now, as you might expect, what this will allow us to do is apply filters that are based on both text and value attributes at the same time. So, in this case, what we're going to do is filter down to titles that end in the number two, which is a label filter, and also drove a certain volume of revenue…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
Customizing the field list4m 7s
-
(Locked)
Autofitting column width4m 21s
-
(Locked)
Outline and tabular layouts7m 46s
-
(Locked)
Counting nonnumerical fields6m 5s
-
(Locked)
Grouping dates8m 3s
-
(Locked)
Enabling multiple filters5m
-
(Locked)
Grouping values6m 50s
-
(Locked)
Adding value calculations9m 1s
-
(Locked)
Showing empty items6m 22s
-
(Locked)
Configuring slicers and timelines10m 23s
-
(Locked)
Conditional formatting8m 23s
-
(Locked)
Removing and reviving source data8m 19s
-
(Locked)
Adding custom sort lists5m 23s
-
(Locked)
Solve order and list formulas6m 16s
-
-