ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / Developing an application or website / Controls, windows and pages / Controls: Available types / Pivot Table control
  • Overview
  • Main characteristics of Pivot Table control
  • "General" tab
  • "UI" tab
  • "Details" tab
  • "Content" tab
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Overview
The description window of a Pivot Table control is used to configure several elements of the control.
This help page presents the settings that can be performed in the different tabs found in the description window of control.
Reminder: To display the Pivot Table control's control description window, select "Description" from the field's context menu..
Main characteristics of Pivot Table control

"General" tab

The "General" tab found in the description of the Pivot Table control is used to define:
  • position of displayed values: Several values can be displayed in the Pivot Table control.. The values can be displayed:
    • side by side:
    • one below another:
  • totals position: The Pivot Table control can total the values displayed.. The totals can:
    • be displayed at the bottom right (at the end of row and column).
    • be hidden.
    • be displayed at the bottom only (at the end of column).
    • be displayed on the right only (at the end of row).
    The option "Totals always visible" allows you to display the totals at the end of the row and/or column even if the row or column is not fully displayed. In this case, the totals are always visible.

"UI" tab

The "UI" tab is mainly used to:
  • define the initial status of the control.
  • define the context menu associated with the control (menu of AAFs, custom menu, ...).
  • define the selection mode. The option "Allow the multiple selection of rows, columns and cells" allows the user to select several columns, rows or cells at the same time. The options proposed by the menu of AAFs are applied to all the selected cells (copy, background color, ...).
    You also have the ability to define the selection mode through programming with Multi-selection.

"Details" tab

The "Details" tab mainly allows you to:
  • configure scrollbars and tooltips (with the possibility to display a tooltip on truncated elements).
  • enable line wrapping in the row headers. You can also configure this option programmatically, using the AutoLineWrap property.
  • save the user settings. These settings will be restored automatically the next time the window is opened.

"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:
  1. Click "Add".
  2. Define the link from the source file to reach the item that will be used as filter and validate.
  3. On the right-hand side of the screen, define the characteristics of the displayed value.
  4. 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:
  1. Click "Add".
  2. Define the link from the source file to reach the item that will be displayed as header and validate.
  3. On the right-hand side 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:
  1. Click "Add".
  2. Define the link from the source file to reach the item that will be displayed as header and validate.
  3. On the right-hand side 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 reorganize 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: Allows you to define:
    • the name of the value. This name is used to handle the value programmatically.
    • the caption of each value displayed in the cell.
      This label can also be programmed using the Caption property..
  • Calculation: Defines the calculation performed, the source used and the display mask for the value in the crosstab array..
  • Display: Allows you to define value display options: alignment, blanking, total label (row or column)., ...
    It is also possible to define "eye-magnet" (contditional formatting) on values: for example, all cells in a Pivot Table control whose value is negative can be displayed in red.
To go back to the initial "Content" tab, click the arrow at the top of the screen ().
Minimum version required
  • Version 18
Comments
Click [Add] to post a comment

Last update: 09/21/2024

Send a report | Local help