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.
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.