Microsoft Office Tutorials and References
In Depth Information
Creating a More Complex Pivot Table
This workbook is available on the companion CD-ROM. The file is named budget
pivot table.xlsm .
Figure 17-4 shows a pivot table created from the data. Notice that the pivot table contains a
calculated field named Variance . This field is the difference between the Budget amount and the
Figure 17-4: A pivot table created from the budget data.