I am attempting to create a PivotTable where my team can select their name as the report filter to view their activity. In the data, there are two fields where a team member could indicate that they're working on an account (two team members per account). Is there a way to create the PivotTable (or create another column in the data which the pivot can pull from) so that they only have to select their name once, regardless if it's in the first or second column? Simplified sample spreadsheet is attached.
Thanks!
Bookmarks