Pivots

A PivotTable is a tool for analyzing data, performing calculations, and creating summaries that allows you to see comparisons, patterns, and trends emerging from your data. It allows you to filter, select and rearrange columns and rows of data to obtain a more transparent and useful data layout.

The following issues will be discussed:

• the principle of operation of pivot tables

• how to create them

• attributes, aggregators and their parameters.