Multi-level pivot report style options

Change the look of your multi-level pivot report.

When you create or edit a report, click the gear icon (The gear icon) after the Type field. Use the options in the Style your chart dialog box to configure the look of your chart. Chart options are automatically saved when you click Close. To see how the chart looks with the saved settings, click Save.

Table 1. Chart style options
Field Description
General
Display Zero Select this check box to display the number 0 when the value of a cell is 0. Clear this check box to display an empty cell when the value of the cell is 0. Applicable when Aggregation is Count or Count Distinct.
Drilldown view List view to display when a user selects a segment of a report for which no drilldown report type is specified. This view is also used when the user reaches the lowest drilldown level of a report. See Configure the list layout . If you specify a Report drilldown, Drilldown view is ignored.
Note: All users can view report visualizations, such as pie charts and column reports. However, the last level of a drilldown is always a list. Platform access control lists determine user access to list information. Users who do not have rights to any part of the list data see the message "Number of rows removed from this list by Security constraints:" followed by the number. See Access control rules.

For more information, see Define a report drilldown.

Edit coloring rules Click this hyperlink to configure how cells and cell text with numerical values are colored in the report. You can create rules to define which colors are used based on operators and values. For example, you can specify that any value greater than 5 displays in red. See Create coloring rules for multilevel pivot table reports.
Decimal precision Number of decimal places to display. You can display up to four decimal places. By default, whole numbers are displayed.
Title
Show chart title When the chart title is displayed for the report.
  • Never: Never displays the chart title.
  • Report only: Displays the chart title on reports.
  • Always: Displays the chart title on reports, and dashboards and homepages.
Chart title The chart title has a maximum length of 40 characters. If no title is entered, the report name is used for the title. This field appears when Report only or Always is selected from the Show chart title list.
Size of the chart title Size of the chart title in pixels. This field appears when Report only or Always is selected from the Show chart title list.
Chart title color Color of the chart title. This field appears when Report only or Always is selected from the Show chart title list.
Custom chart title position Check box to specify X and Y coordinates for the position of the chart title. This field appears when Report only or Always is selected from the Show chart title list.
Title horizontal alignment How the chart title is aligned horizontally. This field is available when Custom chart title position is cleared.
Title vertical alignment How the chart title is aligned vertically. This field appears when Custom chart title position is cleared.
Chart title X position Number of pixels to adjust the chart title position right or left. By default the title appears at the center top of the chart. To move the chart title to the right, enter a positive value. To move the title to the left, enter a negative value.

This field appears only when Custom chart title position is selected.

Chart title Y position Number of pixels to adjust the chart title position up or down. By default the title appears at the center top of the chart. To move up the chart title, enter a positive value. To move the chart title down, enter a negative value.

This field appears only when Custom chart title position is selected.