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.