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 ...

Get The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.