I am trying to insert a calculated item on my pivot table that calculates the Profit margin. I have two columns Revenue and Expense and would like to add a third column "Profit Margin". The calculated column would look like this "Profit Margin = (Revenue-Expense)/Revenue". No matter where I click in the pivot table both the Calculated Field and Calculated Items options are grayed out within the "Fields, Items, & Sets" section.
Here is my excel file.
November Revenue.zip
Bookmarks