PVTCollapse (Function) - PC SOFT - On-line documentation

PC SOFT

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

WINDEV

Windows

Linux

Universal Windows 10 App

Java

Reports and Queries

User code (UMC)

WEBDEV

Windows

Linux

PHP

WEBDEV - Browser code

WINDEV Mobile

Android

iPhone/iPad

Apple Watch

Universal Windows 10 App

Windows Mobile

Others

Stored procedures

PVTCollapse (Function)

In french: TCDEnroule

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 Pivot Table control to use.

<Header to collapse>: Character string (with or without quotes)

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 : wd250obj.dll

See also

Minimum version required

Version 18

This page is also available for…

Comments

Click [Add] to post a comment

Last update: 06/05/2019

Send a report | Local help

Close this window

Searching...

Annotate the page

Title:

J'accepte les termes de la licence

How to browse local help?

All you have to do is configure your product as follows:

Select "Tools .. Options .. General options of …".
In the "Help" tab, select "Use the local help database" and specify (if necessary) the path of the "Help" directory of your product.
Validate. The help used by default will be the local help installed on your computer.