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:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Resources[/TD]
[TD]Resources[/TD]
[TD]Resources[/TD]
[TD]Resources[/TD]
[TD]Expenses[/TD]
[TD]Expenses[/TD]
[TD]Expenses[/TD]
[TD]Expenses[/TD]
[TD]Expenses[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Resource1[/TD]
[TD]Resource2[/TD]
[TD]Resource3[/TD]
[TD]Resource4[/TD]
[TD]Expense1[/TD]
[TD]Expense1[/TD]
[TD]Expense1[/TD]
[TD]Expense1[/TD]
[TD]Expense1[/TD]
[/TR]
[TR]
[TD]Tasks[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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