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
Collapses the data found in a Pivot Table control according to a row header or to a column header.
Example
// Collapses all quarters
PVTCollapse(PVT_Sales, COL_OrderDate_Quarter)
Syntax
PVTCollapse(<Pivot Table control> , <Header to collapse>)
<Pivot Table control>: Control name
Name of the Pivot Table control to be used.
<Header to collapse>: Character string
Name of the row header or column header to collapse.
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.
Business / UI classification: UI Code
Component: wd290obj.dll
Minimum version required
  • Version 18
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 09/04/2023

Send a report | Local help