Creating a table

Pivot tables are created from Query Builder. Open a query document to select it as a data source for a pivot table. In the Database Explorer, select required tables from your database and drag-and-drop them to the query document. They are displayed as shapes with columns. In required table shapes select corresponding check boxes.

Switch to the Pivot Table view to see the pivot table template. The Data Source view opens automatically with the fields specified in our query document. To add fields to the pivot table, simply drag-and-drop them from the Data Source view to a required pivot table area.

Sorting and grouping fields

Sorting data in a pivot table allows displaying it in ascending or descending order.

You can group data in an Oracle pivot table using various predefined group modes. Grouping values of some field is done with a single click of your mouse. It will appear as a new sub-field and you will be able to add it to a required area in your pivot table.

Values of date and time type can be grouped by years, months, quarters, weeks, days, etc. Numeric data can be grouped into numeric ranges. Text data can be grouped by first letter.

Besides predefined group modes, you can create your own group criteria using the Collection Editor dialog box.

Using summary functions to calculate custom totals

Pivot Table offers you a number of summary functions that can be applied to calculate custom totals for column or row values. Custom totals are displayed in additional rows or columns highlighted in grey.