6 Format the values with Accounting Number Format with 7.000 two decimal places.
7 In cell B3, create a custom heading named
4.000
Replacement Value. Change Row Labels in cell A3 to Retired Colors.
8 If necessary, display the Excel Options dialog box, click
10.000
Customize Ribbon on the left side of the dialog box, click to select the POWERPIVOT check box in the Customize the Ribbon section on the right side, and then click OK. Use the Calculated Fields command to create a new calculated field. Enter the formula to multiply [ Sum of Replacement Value ] by1.15. Add the calculated field to the Values area of the PivotTable.
9 In cell C3, type the custom name Updated
6.000
Replacement Values. Word-wrap and center the label. Set the Column C width to 12.