The next time you need a complex filter in your Pivot Table, remember this trick from Excel Video 321. We’ve discussed manual filters, label filters, and value filters in these Excel Videos. The filters are great, but normally you can only use filter at a time. If you have a value filter and switch to a label filter, Excel will remove the value filter when it implements the label filter. To change that behavior, go to the Pivot Table options menu and the Totals & Filters tab. Check Allow multiple filters per field and you can now use multiple filters at once.
I hope you had a great holiday and look forward to seeing you for many more Excel tips in 2013. Thanks for watching.
