Analyzing content

The analysis features of the Pivot section are the most commonly used data analysis features in Interactive Reporting. The Pivot section provides the ability to Focus, Hide, and Drill into columns of data to easily locate and explore datasets. To demonstrate each of the three analysis features, the sales and cost example from previous chapters will be used. The following screenshot shows a Pivot configured with sales and cost across regions.

Drill

The concept of drilling into data has become of one of the most commonly used terms in data analysis, where drilling provides the ability to start at a high-level dataset and explore the details of a particular section of data. The Interactive Reporting Pivot concept of drilling is similar, where the software allows the ability to drill into another data element available in the parent section of data. When a Drill is initiated, Interactive Reporting freezes the data item(s) selected for the drill and removes all of the other items...