To Create a Calculated Field in the Power Pivot Window by using the Calculation Area
- Click Home> View> Calculation Area.
- Click on an empty cell in the Calculation Area.
- In the formula bar, at the top of the table, enter a formula in this format <calculated field name>:<formula>, eg rate:=SUM([a])/SUM([b])
- Press Enter to accept the formula.