MS Access for the Business Environment: Create a PivotChart View in Access - Page 5
August 4, 2003
Adding Calculated Detail Fields and Calculated Totals
Let's round out our data presentation with the addition of derived detail data via calculated fields and calculated totals. These calculations can make our PivotTable, and ultimately our PivotChart, far more useful to information consumers, as we will see by taking the following steps:
The PivotTable Field List appears (unless already present), with a new field, whose default name is Calculated, appearing at its bottom. In addition, the Properties dialog for the new Calculated field appears, typically in front of the PivotTable Field List, defaulted to show the Calculation tab.
NOTE: For comments and recommendations on the use of the Insert Reference To button, see our last lesson, Create a PivotTable View in Access.
The Properties box, Calculation tab, appears as shown in Illustration 13.
The Properties box, Format tab, appears as shown in Illustration 14.
The new Total Net Sale calculated detail field appears within our PivotTable.
The AutoCalc button, complete with its cascaded menu, is shown in Illustration 15.
NOTE: For comments on the use of the AutoCalc button, see our last lesson, Create a PivotTable View in Access.
Our PivotTable now appears as partially shown in Illustration 16 .
We have successfully created a PivotTable view with calculated detail fields and calculated totals. Now let's build a PivotChart view based upon our PivotTable data, and organize and format our data presentation within the PivotChart to enhance its value to information consumers.