Excel Table Slicer - 1 slicer for each subcategory

[dumitrudan608]

Hi Everyone,

The short question would be this: Is there a way to insert slicers for each of the subcategories from a Pivot table?

To expand the question and give you a bit more details:
I'm working on updating the UI for an excel sheet with a long list of columns that contain information about each task on rows.

This would be the schema of the current situation:

	Resources	Resources	Resources	Resources	Expenses	Expenses	Expenses	Expenses	Expenses
	Resource1	Resource2	Resource3	Resource4	Expense1	Expense1	Expense1	Expense1	Expense1
Tasks

<tbody>
</tbody>

I want to insert 1 slicer for Resources and 1 for Expenses, so i can independently hide the columns from each of the 2 categories.
Can anyone give me some pointers on that?

Kind regards,
Daniel