Share this Page URL

Chapter 11. Analyzing Data with PivotTab... > Changing the View of Data in a Pivot... - Pg. 391

Analyzing Data with PivotTables and PivotCharts 391 In the query that provides the data for this PivotTable, we used an expression to calculate the dollar amount of each order and then added that field to the PivotTable. You can also create calculated fields when you're working with the PivotTable. For example, let's say that North- wind pays a sales commission of 7.5 percent on the amount ordered. We can create a new detail field to calculate the commission and then use the AutoCalc button to subtotal the