A PivotTable report provides an interactive method to quickly and easily summarize large
amounts of data (without the need to export the data to an external database system like
Microsoft Access or an external reporting tool).
Here are some examples of when you might want to use a PivotTable to display your data:
??? To query large amounts of data and create different views
??? To aggregate and subtotal data, and/or create custom calculations and formulas
??? To expand and collapse levels of data
??? To move rows to columns or columns to rows to see different summaries of the source
data (hence the termpivot)
PivotTables enable you to take huge amounts of data and present a concise, easy-to-read
view of that data.
Putting Data into a PivotTable Report
In the Download section for this book on the Apress web site, find the file named
PivotTable01.xlsx and open it.
Remember our fictitious band ???VBA??? from Chapter 1? Well, they??™ve been out touring
and their manager wants to see what??™s selling and what??™s not, and where items are selling
best. PivotTable01.xlsx contains sales data from the first quarter of their tour, as shown in
Figure 6-1.
223
C H A P T E R 6
Figure 6-1. Tour sales data
A good way for the manager to look at this data is via an Excel 2007 PivotTable report.
We??™re going to record a macro while we create a PivotTable. Then we??™ll take a look at some of
the properties and methods available to us.
1. Start the Macro Recorder (Developer ribbon ?¤ Record Macro).
Pages:
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220