By default the the filters won't work this way, but if you create a calculation in your workbook that defines what you want to keep then you can apply the calculation as a filter.
For example, if I only wanted data for 2017 OR Chairs as a sub-category, I would write an equation like this:
IF YEAR([Order Date]) = 2017
OR [Sub-Category] = "Chairs"
I would then use this calc as an Extract Filter and have it only return '1' values. That should do it.
Attached is an example workbook.
If this post assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Oh, yeah, I forgot you could use calculated fields! Thanks for the reminder.