"Content" tab
The "Content" tab allows you to view and configure the different elements of the Pivot Table control. This tab is divided into several sections:
1. Source file of the Pivot Table control. This file corresponds to the data file containing the value used for the calculation. For example, the OrdLine data file to calculate sales.
2. Display filters (advanced use). This list allows you to view the display filter(s) used on the Pivot Table control. These filters can be used by
PVTFilter.
To add or modify the filters, all you have to do is click inside the section. The details of filters are displayed.
To create a new filter:
- Click "Add".
- Define the link from the source file to reach the item that will be used as filter and validate.
- In the right section of the screen, define the characteristics of the displayed value.
- To go back to the initial "Content" tab, click the arrow at the top of the screen (
).
3. Rows. This list is used to view the items displayed on the row headers of the Pivot Table control. These items are used to group the data.
To add or modify the row headers, all you have to do is click inside the section. The details of the row headers are displayed.
The following information is displayed for each row header:
- in the table, the link between the source file and the header.
- on the right, the characteristics of the value displayed in the row header:
- Displayed source. The red arrow is used to defined the sort on the source.
- Filter applied onto the displayed source. For more details, see Filtering the headers.
- Name of header (to be used through programming)
- Display mask of header
- Default status of header (collapsed or expanded).
To add a new row header:
- Click "Add".
- Define the link from the source file to reach the item that will be displayed as header and validate.
- In the right section of the screen, define the characteristics of the displayed value.
To go back to the initial "Content" tab, click the arrow at the top of the screen (
).
4. Columns. This list is used to view the items displayed on the column headers of the Pivot Table control. These items are used to group the data.
To add or modify the column headers, all you have to do is click inside the section. The details of the column headers are displayed.
The following information is displayed for each column header:
- in the table, the link between the source file and the header.
- on the right, the characteristics of the value displayed in the column header:
- Displayed source. The red arrow is used to defined the sort on the source.
- Filter applied onto the displayed source. For more details, see Filtering the headers.
- Name of header (to be used through programming)
- Display mask of header
- Default status of header (collapsed or expanded).
To add a new column header:
- Click "Add".
- Define the link from the source file to reach the item that will be displayed as header and validate.
- In the right section of the screen, define the characteristics of the displayed value.
To go back to the initial "Content" tab, click the arrow at the top of the screen (
).
5. Values to display in the Pivot Table control. This list is used to view the values displayed in the cells of the Pivot Table control.
To add, modify, delete or re-organize these values, all you have to do is click inside the section. The details of the values are displayed.
The characteristics of values are grouped in 3 themes:
- General: Used to define:
- the name of the value. This name is used to handle the value through programming.
- the caption of each value displayed in the cell. You can also change this text programmatically, using the Caption property.
- Calculation: Used to define the calculation performed, the source used and the display mask for the value in the table.
- Display: Used to define the display options of the value: alignment, reset, caption of total (in rows or in columns), ...
You can also define the "eye-magnet" (conditional formatting) on the values: you can for example display in red all the cells of a Pivot Table control whose value is negative.
To go back to the initial "Content" tab, click the arrow at the top of the screen (
).