Having a hell of a time figuring this one out. I'm far from an advanced user, but I'm typically pretty comfortable.

I've got some data with several different categories and need a pivot table to reflect that, such that I can filter by category of both row and column. For example: (pardon the crude attempt at formatting)

[------][----][--------- Vegetables --------][---------- Fruit---------][----------Meat------]
[State][City][Lettuce][Cucumber][Pepper][Apple][Orange][Peach][Beef][Pork][Poultry]
[OH ][Cinc]
[OH ][Tole]
[OH ][Colu]
[OH ][Clev]
[CA ]
[CA ]
[NY ]
[NY ]

Ideally, I'd be able to apply the typical filter by State, but also be able to apply a filter for Food Type, which would allow me to select "OH" and "Vegetables", or what have you.

Thanks!

Oh, and I'm using Office 2016. That's probably important to mention.