Hello, I have a pivot table (see attached).
What I am trying to get is - for each Project Manager, what percentage of their total work for a month is for each client? All the data is already there to make the calculation, but any way I try to create the calculated field I am getting an error.
Can I do this within the pivot table, without modifying anything in the source data?
In this case, Project Manager 7 is the only one across more than 1 client. So I would need to take their total for Client 1 (25249.51) and Client 2 (69140.1) and get what percentage those are of their Month 1 (9438961) total.
In case the attachment doesn't work, this is what it looks like -
![Screenshot 2023-10-10 at 5.25.05 PM.png Screenshot 2023-10-10 at 5.25.05 PM.png](https://chandoo.org/forum/data/attachments/85/85551-976160e3cec694af62a08b9f89bf7479.jpg)
What I am trying to get is - for each Project Manager, what percentage of their total work for a month is for each client? All the data is already there to make the calculation, but any way I try to create the calculated field I am getting an error.
Can I do this within the pivot table, without modifying anything in the source data?
In this case, Project Manager 7 is the only one across more than 1 client. So I would need to take their total for Client 1 (25249.51) and Client 2 (69140.1) and get what percentage those are of their Month 1 (9438961) total.
In case the attachment doesn't work, this is what it looks like -
![Screenshot 2023-10-10 at 5.25.05 PM.png Screenshot 2023-10-10 at 5.25.05 PM.png](https://chandoo.org/forum/data/attachments/85/85551-976160e3cec694af62a08b9f89bf7479.jpg)