Summary

The focus of this chapter was to provide the business analyst the features necessary to effectively analyze and present content in a Pivot section. The chapter started with the methods for creating and adding content to a Pivot and continued with an overview to managing Pivot headings and labels. The chapter addressed the methods for sorting a Pivot using the text labels and Fact elements. The chapter explored the data analysis capabilities of the tool and the concept of drilling, focusing, and hiding to analyze content. The chapter provided steps used to add totals and computed items providing additional data manipulation and calculations. The chapter continued with an overview of the different formatting options including Conditional Formatting, and the chapter concluded with methods for effectively printing and exporting a Pivot for further analysis.