Chapter 6. Pivots
Pivots are one of the most widely used tools for analyzing and presenting data. Interactive Reporting Pivots provide the business analyst with a very effective method to summarize and analyze a dataset, providing the ability to quickly modify, compute, and rearrange data while easily repopulating the dataset with new data. Pivots are very useful in presenting data, where the sections can be analyzed individually or included in Dashboards and Reports. The focus of this chapter is to demonstrate the features of the Pivot used to effectively analyze and present content.
This chapter covers:
Creating pivots
Methods for adding content
Managing pivot headings
Sorting
Analyzing content
Totals and computed items
Formatting and conditional formatting
Methods for exporting and printing
