Skip to main content

Pivot Tables with Multiple Measures

Pivot Tables with Multiple Measures

If you drag and drop multiple measures to the Measures box, you can specify whether the measures are used as columns (as in the default case) or as rows. To do so, click the Options button in the Measures box. The system displays a dialog box; for this discussion, use the options in the section Place measures on. Choose one of the following:

  • Rows — Displays the measures as rows.

  • Columns — Displays the measures as columns.

Then click OK.

This option makes it easier to redefine complex pivot tables, because you can rearrange the Rows box or Columns box and leave the measures alone.

For example, consider the following pivot table definition:

Rows=Decade,Columns=Gender,Measures=Patient Count, Avg Allergy Count

By default, the measures are used as columns (nested within the elements listed in the Columns box), as in the following example:

Rows=decades;columns=the two measures shown separately for females and males

If you instead use the option to display the measures as rows, the pivot table looks like this:

female & male columns;rows have measure values by decade, with decade as outer row grouping

This pivot table is equivalent to one defined as follows:

Rows=Decade with 2 measures below & to the right; Columns=Gender

FeedbackOpens in a new tab