Pivot Tables
When dealing with data, one often beats his brains with grouping, sorting, or doing
anything else to get required results and grasp the whole picture. The Pivot Table
tool is designed exactly to end these miseries and enable you to categorize any
obscure data with several mouse clicks.
Pivot Table is a tool that converts large amounts of data into compact and informative
summaries - pivot tables. You can rearrange (or pivot) your data by a simple drag
of a mouse until you get the best layout for understanding the data relations and
dependencies.
When working with pivot tables, you may find useful:
-
Convenient and modern design to categorize any obscure data into compact and informative
summaries - pivot tables
- Momentary change of data display via drag-and-drop
-
Wide choice of styles to change a pivot table appearance; convenient editor to
add conditions and set up styles
- Automatic function calculation
-
Various summary functions to calculate custom totals for required column or row
fields
-
Different types of filtering and grouping to display only required data in a pivot
table; smart Prefilter dialog to apply advanced filtering conditions
Note: table designer does not generate pivot SQL queries that can
be used outside of the program.