Aggregation of data (summarization, counting, averaging) can be done with the help of functions that have one or more of the conditions under which calculation is performed. These are very useful functions because they allow complex analyzes and an efficient way to make summary reports. In the following text we will describe these functions through several examples …
Data aggregation represents a mathematical operation (summarization, counting, averaging) that we perform over a set of data. Conditional aggregation, as its name implies, is performing data aggregation over a set of data that meets certain condition which is contained within a given data range. In this “recipe” we’ll cover functions that use single condition for performing aggregation.
Pivot charts have almost all properties as standard charts that are used to visualize reporting data. They are specific in that they are always in relation to the Pivot table on the basis of which they were created or by some other data source (Data Model). Changing data in the Pivot table, e.g. by adding a new report dimension, the Pivot chart is automatically updated. You can find out more about Pivot Charts in the text that follows …
Filtering the Pivot table report can also be done with the help of interactive filters, which are: slicers timeline. These are graphics objects that can be used, both with Pivot tables and structured tables. Slicers are made on the basis of the specified reporting dimension, and can be interlinked, according to the principle of subordinates and superiors. Timeline filters are made exclusively based on time-related reporting dimensions.
Before we create a Pivot table, it is important that we have a well-defined data source. Columns of the table represent the reporting dimensions (dimensions and measures) and before we begin to make the report it would be useful to prepare well all the reporting dimensions. However, it is sometimes necessary to add some new dimension “on the go” and it is therefore useful to know how to use the Calculated Fields and Calculated Items features.