Database Reference
In-Depth Information
The INSERT
command tab
The PivotTable
command button
(g) The PivotTable Command
The Create
PivotTable dialog
box
This is the
imported data in
the table in the
worksheet
Select the New
Worksheet radio
button if necessary
The OK button
Figure 12-21
Continued
(h) The Create PivotTable Dialog Box
In an OLAP report, it is also possible to change the order of the dimensions. Figure 12-23
shows city quantities as vertical data and ProductID quantities as horizontal data. This OLAP
report shows quantity sold by city and by product, customer, and year.
Both displays are valid and useful, depending on the user's perspective. A product man-
ager might like to see product families first (ProductID) and then location data (city). A sales
manager might like to see location data first and then product data. OLAP reports provide
both perspectives, and the user can switch between them while viewing a report.
 
Search WWH ::




Custom Search