Hello everyone,
I'm struggling with a problem on a pivot table. I have some data that looks like this
<tbody>
</tbody>
This goes on for 60 clients across the whole year. What I need to do is be able to sum up the billing amount by month (which is easy) but I also want to include a column in my pivot table that shows the management fee per month per client. I've tried using Max however this won't work if I want to show all of the combined fee's per client per month and I also can't add a total column to show the total billing amount! I'm totally stumped so any help would be appreciated!
I'm struggling with a problem on a pivot table. I have some data that looks like this
Date | Month | Management fee | Client | Billing amount |
01/01/19 | January | 200 | Client 1 | 500 |
01/01/19 | January | 250 | Client 2 | 250 |
01/02/19 | January | 200 | Client 1 | 560 |
01/02/19 | January | 250 | Client 2 | 254 |
<tbody>
</tbody>
This goes on for 60 clients across the whole year. What I need to do is be able to sum up the billing amount by month (which is easy) but I also want to include a column in my pivot table that shows the management fee per month per client. I've tried using Max however this won't work if I want to show all of the combined fee's per client per month and I also can't add a total column to show the total billing amount! I'm totally stumped so any help would be appreciated!