Data analysis

Last modified: May 28, 2025

This section provides tools and techniques for analyzing data using pivot tables and the Master-Detail Browser. It covers creating pivot tables and charts, organizing fields through sorting, grouping, and filtering, applying summary functions, and customizing layouts with conditional styles. Guidance is also included for printing pivot tables and understanding key components such as headers, totals, and data areas.

In this section

Pivot table overview

Create a pivot table

Create a chart in a pivot table

Reorder fields

Filter fields

Sort fields

Group fields

Use summary functions to calculate custom totals

Apply conditional styles

How to print a pivot table

Areas

Filter field

Headers

Column field

Row field

Data field

Totals

Grand totals

View data in related tables

Work with self-referencing tables in Master-Detail Browser

Work with a Master-Detail Browser document

Sort and filter data in Master-Detail Browser

Tips for working with Master-Detail Browser