Row Fields and Column Fields indicate in which groups the result will be sorted in
the rows and columns. If there are no entries in one of these area, then partial sums
will not be provided for the corresponding rows or columns. Often more than one
field is used at the same time get partial sums for rows or columns. The order of the
fields gives the order of the sums from overall to specific.
For example, if you drag region and employee into the Row Fields area, the sum will
be divided into the employees. Within the employees will be the listing for the
different regions.
Fields that are placed into the Page Fields area appear in the result above as a drop
down list. The summary in your result takes only that part of your base data into
account that you have selected. For example, if you use employee as a page field,
you can filter the result shown for each employee.
To remove a field from the white layout area just drag it to the border and drop it (the
cursor will change to a crossed symbol), or click the Remove button.
More options
To expand the DataPilot and show more options, click More.
Komentáře k této Příručce