Hi,
Can i customize pivot table row field with some formula instead?
2.jpg
i made an example that you can see in the picture above. The goal is to made a summary of how much the sales person(SP) made using pivots (SP Performance). I need to use pivots so i can make slicer tool of selected salesperson.
If someprojects is handled by more than 1 SP, the amount should be fully added on both SP Performance
If anyone has suggestion to handle the raw data, or how to customize the pivots please help me.
Feel free to ask by the way, Thanks before
Bookmarks