Hi All,
I have a spreadsheet that contains:
* Company Name
* Opportunity Name
* Rep Name
* Total Profit.
There might be several opportunities per company name, with different reps associated.
I want to be able to select one rep from a list - like a slicer - and have the pivot table show me a list of the companies & ops that rep belongs to - but also all the other reps & their opportunities against that company -so that the reps can see who else is working on their accounts and maybe collaborate.
I have about 60 reps, so i'd use a sumifs to make a yes/no per rep v company if I had less, but 60 individual columsn on the pivot would just be a disaster.
Any thoughts?
Bookmarks