Create a calculated field in PowerPivot

Open the Excel workbook which we used in our previous post on this topic. Olympics Excel Work book. Select PowerPivot -> Manage PowerPivot Window will open, If Calculation area not visible below table data as shown in below screen. Click Calculation Area button in Top Right Corner. In the Calculation Area, select the cell directly below… More Create a calculated field in PowerPivot