I am trying to insert a calculated item on my pivot table that calculates the Profit margin. I have two columns Revenue and Expense. The calculated column would look like this = (Revenue-Expense)/Revenue. However 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. Below is a simple view of what my data looks like
Month Revenue Expense Profit Margin(Calculated Item)
9/1/2015 100 20 =(100-20)/100
10/1/2015 80 30 =(80-30)/80
11/1/2015 90 15 =(90-15)/90
How do I insert this calculated column?
Thanks!
Month Revenue Expense Profit Margin(Calculated Item)
9/1/2015 100 20 =(100-20)/100
10/1/2015 80 30 =(80-30)/80
11/1/2015 90 15 =(90-15)/90
How do I insert this calculated column?
Thanks!