ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE
Help / WLanguage / WLanguage functions / Controls, pages and windows / Pivot Table functions
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Collapses all the data in a Pivot Table control according to a row or column header.
New in SaaS
WEBDEV - Server codeLinux This function is now available for WEBDEV websites in Windows and Linux.
Note: This feature is only available from WINDEV Suite SaaS 2025 - Update 4.
For more details, see Using new features exclusive to WINDEV Suite SaaS 2025.
Example
// Collapses all quarters
PVT_Sales.Collapse(COL_OrderDate_Quarter)
Syntax
<Pivot Table control>.Collapse(<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.
Component: wd300obj.dll
See also
Minimum version required
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 07/10/2025

Send a report | Local help