dumitrudan608
New Member
- Joined
- Dec 7, 2010
- Messages
- 19
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:
<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
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
Last edited: