PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview of the 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
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
Overview of the 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:
New in version 21
Notes:
Notes:

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:
  1. Check that your servers are in 64-bit mode (avoid the former technologies in 32-bit mode that limit the memory to 4GB).
  2. 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:
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
video pivo
https://youtu.be/Q8GiLc_C-xw
amarildo
Nov. 15 2018