PC SOFT

WINDEV的在线文档

  • 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
文档页面当前正在翻译。对于此延迟我们深表歉意。
您可以自愿地帮助我们翻译您想要的文档段落,然后只需通过以下地址与我们联系:info@cn.windev.com
产品
WinDevWebDev-服务器代码WebDev-浏览器代码WinDev Mobile报表和查询
平台
WindowsLinuxWindows MobileWindows PhoneWindows Store appsAndroidAndroid Widget iPhone/iPad
语言
JavaPHPAjax用户代码(MCU)外部语言
数据库
HFSQLHFSQL Client/Server存储过程HF 5.5OLE DBODBC本地访问

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.

Note: The Pivot Table operates:

  • on the HFSQL databases,
  • 20版本和更高版本
    on other databases via arrays of structures.
    20新版本
    on other databases via arrays of structures.
    on other databases via arrays of structures.

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.