|
|
|
|
|
|
|
|
|
|
Pivot Table control functions
Note: These functions are also available in prefix syntax ( Functions for managing Pivot Table controls (prefix syntax)). These functions are used to manipulate the Pivot Table controls:
| | | PVTAxisXY | Allows you to: - Specify the row and column headers displayed in a Pivot Table control.
- Find out the row and column headers displayed in a Pivot Table control.
| | PVTCalculateAll | Entirely calculates or recalculates a Pivot Table control. | | PVTCalculateAllAsynchronous | Entirely calculates or recalculates a Pivot Table control, without blocking the application. | | PVTCalculateUpdate | Updates some of the data found in a Pivot Table control from a given date. | | PVTCalculateUpdateAsynchronous | Updates some of the data found in a Pivot Table control from a given date without blocking the application. | | PVTCollapse | Collapses the data found in a Pivot Table control according to a row header or to a column header. | | PVTCollapseAll | Collapses all row and/or column headers in a Pivot Table control. | | PVTCompareDateRange | Calculates and displays a date range comparison in a Pivot Table control. | | PVTExpand | Expands the data found in a Pivot Table control according to a row header or to a column header. | | PVTExpandAll | Expands all row and/or column headers in a Pivot Table control. | | PVTFilter | Enables or disables a filter on a Pivot Table control. | | PVTHeaderValue | Returns the value displayed in a header of Pivot Table control. | | PVTInfoXY | Returns the values of headers corresponding to a position in a Pivot Table control in pixels. | | PVTListPositionHeader | Returns all values associated with a row or column header in a Pivot Table control. | | PVTLoad | Loads the result of the calculation performed in a Pivot Table control from a backup (file found on disk or backup in a buffer). | | PVTSave | Saves the result of the calculation performed in a Pivot Table control (in a file or in memory). | | PVTSelect | Allows you to find out the position of selected cells and to select cells in a Pivot Table control. | | PVTSelectCount | Returns the number of selected cells in a Pivot Table control. | | PVTToExcel | Creates an Excel file with data from a Pivot Table control. |
Related Examples:
|
Training (WINDEV): WD PivotTable
[ + ] This example presents the use of the Pivot Table control. This Pivot Table control is used to display dynamic statistics while grouping the data. These statistics are calculated form the database.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|