ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Controls, pages and windows / Pivot Table functions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Functions for managing Pivot Table controls (prefix syntax)
These functions are used to manipulate the Pivot Table controls, using prefix 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.
Entirely calculates or recalculates a Pivot Table control, without blocking the application.
<Pivot table>.CalculateUpdateUpdates some of the data found in a Pivot Table control from a given date.
Updates some of the data found in a Pivot Table control from a given date without blocking the application.
<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

Last update: 01/04/2024

Send a report | Local help