Sum of Amount
8.
Try it: Format the Data
Sum of
Amount is money-sales data.
Select
Column B.
Go to
Home->Number.
Click on
Accounting ($).
Select
Column B, again.
Go to
Home->Number.
Click on
Decrease Decimals twice.
Try This, Too: Save the PivotTable
Go to
File->Save As.
Name the
workbook: MyName PivotCharts.
Save.
Save. Save.
Very good.