|Row Field||Identifies the values from the source data assigned to use as the rows of the table.|
|Column Field||Identifies the values from the source data assigned to use as the columns of the table.|
|Data Area||Summarises the data using the assigned summarisation function or custom formula.|
|Data Field||Identifies the values from the source data that are summarised in the Data Area.|
|Items||Identifies a sub category for a row or a column that identifies the corresponding data area values.|
|Page Field||Can be used to filter the values on the page. Only records containing matching values will be displayed. This is optional|
|Grand Totals||A row or column that provides a total for all the cells of the data area.|
|Sub Totals||A row or column that summarises cells within the corresponding detail fields.|
Notice that the label "Sum of Cost" (in cell "B4") is used to identify the Data Area field as well as the operation, in this case SUM.
In this case "Cost" is the Data Field
The values that the Row Field and Column Field contain are also referred to as Items.
Division is the name of the Column Field and its corresponding items (or values) are Marketing, Personnel, Sales and Trading.
This allows you to add a third dimension to your pivot table without displaying all the items at the same time.
These are only visible when you are using multiple fields in either the row or column areas of your table.
You can select a field item and all its corresponding data by pressing the left mouse button when the cursor is over the edge of that item. The cursor will change to a black arrow.
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext