Customizing Pivot Table Items
The Analyzer displays an Advanced Options button in the Rows, Columns, and Measures boxes, next to each item in those boxes. The same button is also available for the Rows and Columns boxes.
For example:
If you click any of these buttons, you see the following dialog box—depicted here with only its top part—or a variation of it (the details are different for measures).
The following sections describe changes you can make.
You can specify formatting in multiple places. If you specify different formatting, the following rules control which formatting options are used:
-
Wherever possible, all the formatting is used. For example, if you specify the typeface to use for rows and the color to use for columns, both format options are applied.
-
Formatting specified for a measure in a pivot table takes precedence over formatting specified elsewhere.
-
Formatting specified for columns takes precedence over formatting specified for rows or the entire pivot table.
-
Formatting specified for rows takes precedence over formatting specified for the entire pivot table.
-
Formatting specified in the pivot table takes precedence over formatting specified in a measure definition (other model elements do not have format options).