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 .