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
Remark: 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:
PVTAxisXYUsed 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.
PVTCalculateAllEntirely calculates or recalculates a Pivot Table control.
New in version 2024
PVTCalculateAllAsynchronous
Entirely calculates or recalculates a Pivot Table control, without blocking the application.
PVTCalculateUpdateUpdates 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.
PVTCollapseCollapses the data found in a Pivot Table control according to a row header or to a column header.
PVTCollapseAllCollapses all row and/or column headers in a Pivot Table control.
PVTCompareDateRangeCalculates and displays a date range comparison in a Pivot Table control.
PVTExpandExpands the data found in a Pivot Table control according to a row header or to a column header.
PVTExpandAllExpands all row and/or column headers in a Pivot Table control.
PVTFilterEnables or disables a filter on a Pivot Table control.
PVTHeaderValueReturns the value displayed in a header of Pivot Table control.
PVTInfoXYReturns the values of headers corresponding to a position in a Pivot Table control in pixels.
PVTListPositionHeaderReturns all values associated with a row or column header in a Pivot Table control.
PVTLoadLoads the result of the calculation performed in a Pivot Table control from a backup (file found on disk or backup in a buffer).
PVTSaveSaves the result of the calculation performed in a Pivot Table control (in a file or in memory).
PVTSelectAllows you to find out the position of selected cells and to select cells in a Pivot Table control.
PVTSelectCountReturns the number of selected cells in a Pivot Table control.
PVTToExcelCreates 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 18
Comments
NESSA AULA VAMOS VER PIVO
BOA NOITE.
NESSA AULA VAMOS VER PIVO

// BLOG COM VIDEO E EXEMPLO


http://windevdesenvolvimento.blogspot.com.br/2017/07/aula-1216-windev-pivo-009-criando-pivo.html

https://www.youtube.com/watch?v=9i2pjCCXxnM


De matos
21 Jul. 2017

Last update: 01/04/2024

Send a report | Local help