Pro tip: Enabling multiple filters

- [Instructor] So I want to share with you guys…a tip that I wish someone had taught me…years and years ago, which is…how to enable multiple filters in a pivot table.…And this is something that's really easy to do…once you know where to look, because it's kind of buried…in the pivot table options.…So let me show you what I mean here.…Let's go ahead and clear our filter…to give us a starting point.…And let's say we want to drill down…to only titles with a simple label filter, begins with S.…So we're only looking a S titles now.…

And now let's say, okay, I got my S titles.…Among titles that begin with S,…let's filter down again to show only the S titles…with a gross revenue over a hundred million dollars.…So I could go in, when I open up…that sorting and filtering menu,…I see a checkbox next to the label filters line…which indicates that there is a label filter applied.…If I drop into my value filters and choose greater than,…we can say, alright gross revenue…is greater than 100 million, press okay.…

See what happened here?…