Hello,

I'll try to explain this the best way possible, and add some pictures to explain the situation. What I need is to add a field that gives a gross margin percentage for a project.

To begin, I simplified the following data that the Pivot Table is using. Project (10 different projects), Account Number, Account Category (Revenue, and Cost), Debit Amount, Credit Amount, and a manually inserted column named Total (CR Amount - DR Amount). See 1st image. Pivot1.jpg

I have designed the Pivot table so it lays out like this. Pivot2.png Pivot3 (2).png

I have been trying to enter a calculated field that would automatically provide the Gross Margin Percentage. In the 2nd image, the Grand Total is the gross margin, but I am unable to use that as a selection when creating a calculated field.

If someone could provide some assistance, it would be much appreciated.