Hello
On the attached pivot table i have a list of projects in column labels divided up into respective Leger number e.g 3000-3999 which are all the account numbers for revenue. Accounts 4000-4999 are all account numbers for costs. What i need to do is add in a column after grand total that calculates the margin. In the picture attached the margin for materials is 20% (25 341/(126152+2060) i.e profit of materials divides by sum of all accounts from 3000-3999. I played around with % of parent but couldnt get it to calculate it.
Appreciate your help.
On the attached pivot table i have a list of projects in column labels divided up into respective Leger number e.g 3000-3999 which are all the account numbers for revenue. Accounts 4000-4999 are all account numbers for costs. What i need to do is add in a column after grand total that calculates the margin. In the picture attached the margin for materials is 20% (25 341/(126152+2060) i.e profit of materials divides by sum of all accounts from 3000-3999. I played around with % of parent but couldnt get it to calculate it.
Appreciate your help.