Section Properties dialog

Use this dialog to specify the properties for a section of data in a view using the Layout pane.

For more information, see "Setting Properties for View Bodies and Drop Targets."

Components

Column Heading Display

(Available for pivot tables and tables) Displays these options to specify how to display the column heading for the section: None, Above, or Left.

Insert Page Break

Use this area to indicate whether to create a page break before the section, when you export an analysis to PDF, PPT, or Excel or print to PDF. This means that every time a value changes in the section drop target, the new section for that column is displayed on a new page, slide, or sheet. In addition, all other views on the compound layout are rendered on separate pages regardless of the section property break setting. This is useful for data-driven detail analyses.

You can select from the following:

• No Page Break — Do not break pages.

• Each member of all columns — Break at the innermost column, which inserts a page break between every section.

• Each member of the first column — Break at the outermost column, which inserts a page break when the section label in the outermost column changes.

  When the value of an outermost column changes, the value of the inner column is also considered changed. Therefore, setting page breaks at the innermost column inserts manual page breaks between every section.

Show Blank Rows

(Available for pivot tables and tables) Use this box to indicate whether to display rows that have no data in the section. Select the box to display all rows, even if a row is an empty text string and contains no value. Deselect the box to hide rows when there are no results to display. This option might be useful for example, to hide empty address lines.

Maximum number of section slider values

(Available for graphs, gauges, and funnels) Use this box to enter the maximum number of values to display on a section slider bar, but not to exceed the system maximum. The administrator configures the system maximum. If you enter a number that exceeds the system maximum, then it is ignored.

For more information about section sliders, see "Defining Section Sliders in Graphs, Gauges, and Funnels."

The remaining components of this dialog are described in "Column Properties dialog: Style tab."