Goal Seek is one of the What-If tools used to calculate how much to change an argument of a formula, or argument that indirectly affects to it, in order to get a certain result. This is a simple option that can be used, for example, to calculate the sales price of the item that is needed to reach the desired sales level. Learn about the Goal Seek option in the text that follows …
One of the What-If analysis tools are Data tables. It is an option that allows the formula’s arguments to be taken from the rows or columns of a specially formed table and thus automatically populated. In practice, this option is not used as often, but it can be handy when we use functions that have more arguments to see the value of the results depending on the change of arguments.
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.