|
|
|
|
|
|
|
|
|
|
Pivot Table control functions
Note: These functions are also available in prefix syntax ( Pivot Table control functions (prefix syntax)). These functions are used to manipulate Pivot Table controls:
| | | PVTAxisXY | Allows you to: - Set the row and column headers displayed in a Pivot Table control.
- Get the row and column headers displayed in a Pivot Table control.
| | PVTCalculateAll | Calculates or recalculates all the data of a Pivot Table control. | | PVTCalculateAllAsynchronous | Entirely calculates or recalculates a Pivot Table control, without blocking the application. | | PVTCalculateUpdate | Updates part of the data 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 all the data in a Pivot Table control according to a row or 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 all the data in a Pivot Table control according to a row or column header. | | PVTExpandAll | Expands all row and/or column headers in a Pivot Table control. | | PVTFilter | Enables or disables a filter in a Pivot Table control. | | PVTHeaderValue | Returns the value displayed in a Pivot Table control header. | | PVTInfoXY | Returns the values of the headers at a given position expressed in pixels in a Pivot Table control. | | PVTListPositionHeader | Returns all values associated with a row or column header in a Pivot Table control. | | PVTLoad | Loads the result of a Pivot Table control calculation from a backup file located on disk or in a buffer. | | PVTSave | Saves the result of the calculation performed in a Pivot Table control (in a file or in memory). | | PVTSelect | Gets the position of selected cells and selects 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.
|
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|