L
Legacy 102432
Guest
Is it possible to have a Pivot Table that you can filter the results by having a search box?
I currently have a list of tasks with resource names assigned to them, and some tasks have more than one resource name. Currently my pivot table lists the resources as they appear on my table..
Eg..
Task 1 - Ben
Task 2 - Ben, Jan
Task 3 - Jan
Task 4 - Ben, Hannah, Joe
So the pivot table lists the Resource names "Ben, Hannah, Joe" when what I would like is for all of Ben's tasks to appear in one filtered result.
Is this possible?
Thanks
I currently have a list of tasks with resource names assigned to them, and some tasks have more than one resource name. Currently my pivot table lists the resources as they appear on my table..
Eg..
Task 1 - Ben
Task 2 - Ben, Jan
Task 3 - Jan
Task 4 - Ben, Hannah, Joe
So the pivot table lists the Resource names "Ben, Hannah, Joe" when what I would like is for all of Ben's tasks to appear in one filtered result.
Is this possible?
Thanks