PC SOFT

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • Overview
  • Main characteristics of Pivot Table control
  • "General" tab
  • "UI" tab
  • "Content" tab
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
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 description window of the Pivot Table control, select "Description" from the popup menu of control.
Main characteristics of Pivot Table control

"General" tab

The "General" tab found in the description of the Pivot Table control is used to define:
  • the 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:
  • the position of totals: The Pivot Table control can calculate the totals of displayed values. 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 popup menu associated with the control (menu of AAFs, custom menu, ...).
  • Versions 20 and later
    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 by programming with ..Multiselection.
    New in version 20
    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 by programming with ..Multiselection.
    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 by programming with ..Multiselection.

"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. In the right section 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. See Filtering the headers for more details.
    • Name of header (to be used by 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. 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. See Filtering the headers for more details.
    • Name of header (to be used by 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. 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 by programming.
    • Versions 20 and later
      the caption of each data displayed in the cell.
      This caption can also be modified by programming with ..Caption.
      New in version 20
      the caption of each data displayed in the cell.
      This caption can also be modified by programming with ..Caption.
      the caption of each data displayed in the cell.
      This caption can also be modified by programming with ..Caption.
  • 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 row or in column), ...
    Versions 20 and later
    You also have the ability to 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.
    New in version 20
    You also have the ability to 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.
    You also have the ability to 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 ( ).
See also
Minimum version required
  • Version 18
Comments
Click [Add] to post a comment