Create an empty DataPilot table so that you can understand
the concept of DataPilot areas.
Complete the following steps to create an empty DataPilot
table.
- Position the cursor within a range of cells containing
values, row headings, and column headings.
- Click . The Create
DataPilot Table window opens.
- Select the data source and the place for the result.
- Click OK. An empty DataPilot table
displays with instructions and examples.
Before filling values in an empty DataPilot table, you must
understand the concept of DataPilot areas.
Table 1. DataPilot
areasArea |
Definition |
Page |
The area that contains the source data that
you assign to a page (or filter) orientation in a DataPilot table.
Use a page area to filter the entire report based on the selected
item in the DataPilot table. |
Column |
The area that contains the source data that
you assign to a column orientation in a DataPilot table. |
Row |
The area that contains the source data that
you assign to a row orientation in a DataPilot table. |
Data |
Use a data area to display a summary of numeric
data. |