The Pivot Table control

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Overview of Pivot Table control
CAUTION: The calculation time depends on the size of the database and on the number of row and column headers.
Example of pivot table (based on HFSQL data files)
Example

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

The Pivot Table control

Overview of Pivot Table control

The Pivot Table control dynamically displays data coming from the crosscheck of different files found in a database.

This enables you to display the volume of sales according to families of products, products, regions, over time, with or without details.

The Pivot Table operates:

on the HFSQL databases,
Versions 20 and later
on other databases via arrays of structures.
New in version 20
on other databases via arrays of structures.
on other databases via arrays of structures.

Versions 21 and later
Notes:

The content of the Pivot Table control can now be printed via its popup menu. See Printing the content of a pivot table (AAF) for more details.
You have the ability to create a report based on a Pivot Table control. See Pivot Table report for more details.

New in version 21
Notes:

The content of the Pivot Table control can now be printed via its popup menu. See Printing the content of a pivot table (AAF) for more details.
You have the ability to create a report based on a Pivot Table control. See Pivot Table report for more details.

Notes:

The content of the Pivot Table control can now be printed via its popup menu. See Printing the content of a pivot table (AAF) for more details.
You have the ability to create a report based on a Pivot Table control. See Pivot Table report for more details.

CAUTION: The calculation time depends on the size of the database and on the number of row and column headers.

Each case is different: however, if the process time seems to be too long:

Check that your servers are in 64-bit mode (avoid the former technologies in 32-bit mode that limit the memory to 4GB).
Please contact the free Technical Support and include:
- a description of the operations performed
- the pivot table
- the analysis
- the database
- the expected response time and the actual response time
- the technical characteristics of the server (version of SE, capacity of disks, technology of disks, RAM)
- check whether no other consuming process is run on the server (or indicate these processes)

A performance test will be run by the Free Technical Support. If the performances do not seem good enough, an optimization of the pivot table may be performed (in a forthcoming version).

Example of pivot table (based on HFSQL data files)

Example

Let's see an example of pivot table based on HFSQL data files. The main concepts of the pivot table will be presented from this example.

Associated analysis:

Created pivot table:

This table represents the sales of products (organized by categories) per year (years, trimesters and months).

The values coming from the source file are displayed in the middle (1). These values are automatically calculated according to the groups defined.

The row headers and the column headers (2) correspond to the items used to group the data:

In row, in our example, the total of sales is displayed by product and by category. From the source file named "OrdLine", a grouping is performed on the "ProdCap" item of "Product" file, then a grouping is performed on the "CategoryCap" item of "Category" file.
In column, in our example, the total of sales is displayed by date (month, trimester, category). From the source file named "OrdLine", a grouping is performed on the "OrderDate" item of "Order" file.

The totals (3) are automatically calculated.

The creation of a pivot table is performed in the editor via a wizard. See Creating a pivot table for more details.

Related Examples:

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.