Elements and filtering of Pivot tables

Pivot tables have built-in options for applying autofilter to display data relative to rows, columns, and filters. By opening the autofilter menu, data sorting can be performed according to the specified reporting dimension, or it can narrow down the set of displayed values in the table by setting the conditions that relate to the description or value of the data displayed in the report. More about filtering Pivot tables can be found in the text that follows …

Appearance of a pivot table

Once we have created a Pivot table we can change the way it looks. Depending on the settings, the Pivot tables can be distinguished, although all those formatting properties that apply to the traditional Excel tables apply to them. By changing the style and displaying individual table elements (totals, subtotals, headers of rows  and columns), we can change the look of the Pivot table in accordance with the reporting needs.

Creating Pivot tables

Pivot tables (Pivot table reports) are a tool for creating interactive reports based on the range of selected data or structured tables. Columns from source tables are used as reporting dimensions by aggregation of data (measures) or using them to analyze in rows, columns, as filters (dimensions) … Once made, the Pivot tables are easily changed by adding or removing dimensions, giving us more different look at the unique original dataset.