One of the most common tools people use in Excel to create reports is the chart and table tools ... then select Value Field Settings. In the Value Field Settings dialog box, change the calculation ...