PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
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
Functions for managing Pivot Table controls (prefixed syntax)
These functions are used to handle the Pivot Table controls (prefixed syntax):
<Pivot table>.AxisXYAllows 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.
<Pivot table>.CalculateAllEntirely calculates or recalculates a Pivot Table control.
<Pivot table>.CalculateUpdateUpdates some of the data found in a Pivot Table control from a given date.
<Pivot table>.CollapseCollapses the data found in a Pivot Table control according to a row header or to a column header.
<Pivot table>.CollapseAllCollapses all row and/or column headers in a Pivot Table control.
<Pivot table>.ExpandExpands the data found in a Pivot Table control according to a row header or to a column header.
<Pivot table>.ExpandAllExpands all row and/or column headers in a Pivot Table control.
<Pivot table>.FilterEnables or disables a filter on a Pivot Table control.
<Pivot table>.HeaderValueReturns the value displayed in a header of Pivot Table control.
<Pivot table>.InfoXYReturns the values of headers corresponding to a position in a Pivot Table control in pixels.
<Pivot table>.ListPositionHeaderReturns all values associated with a row or column header in a Pivot Table control.
<Pivot table>.LoadLoads the result of the calculation performed in a Pivot Table control from a backup (file found on disk or backup in a buffer).
<Pivot table>.SaveSaves the result of the calculation performed in a Pivot Table control (in a file or in memory).
<Pivot table>.SelectAllows you to find out the position of selected cells and to select cells in a Pivot Table control.
<Pivot table>.SelectCountReturns the number of selected cells in a Pivot Table control.
<Pivot table>.ToExcelCreates an Excel file with data from a Pivot Table control.
Related Examples:
WD PivotTable 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.
Minimum version required
  • Version 23
Comments
Click [Add] to post a comment