PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
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 the Pivot Table controls
These functions are used to handle 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.
PVTCalculateUpdateUpdates some of the data found in a pivot table from a given date.
PVTCollapseCollapses the data found in a Pivot Table control according to a row header or to a column header.
PVTCollapseAllCollapses all the row headers and/or column headers in a pivot table.
PVTExpandExpands the data found in a Pivot Table control according to a row header or to a column header.
PVTExpandAllExpands all the row headers and/or column headers in a pivot table.
PVTFilterEnables or disables a filter on a Pivot Table control.
PVTHeaderValueReturns the value displayed in a header of the Pivot Table control.
PVTInfoXYReturns the values of headers corresponding to a position in a Pivot Table control in pixels.
PVTListPositionHeaderReturns all the 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.
PVTSelectOccurrenceReturns the number of selected cells in a Pivot Table control.
PVTToExcelCreates an Excel file from the data found in a pivot table.
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 required version
  • 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
Jul. 21 2017