Organizing a Report into Sections


After completing this lesson, you will be able to:

  • Organize a report into sections
  • Fold and unfold report data


You can organize data in a block using a section.

A section displays the grouped value and appears as a header outside the block, instead of remaining within the block. More importantly, a break merely groups data within a block, whereas a section groups the entire report. When you have multiple tables and charts in a single report, the sections group the data for all tables and charts according to the section value.

The advantages of sections are as follows:

  • You can project multiple blocks from the same micro cube within a single report, all sub-grouped to the sectioned level.
  • You can insert subtotal cells, repeated in each section, which are created by the simple process of drag-and-drop.

Insert a Section

Create a section with the contextual menu:

Section Format

You can format your report and report elements in order to present the report with a company style.

Select a section and the Format tab to view formatting settings.

The table lists the Display settings:

The table lists the Appearance settings:

The table lists the Layout settings:

Fold and Unfold Report Data

You can hide and display report data by folding and unfolding report elements.

You can fold and unfold sections, breaks and tables if they have a header or a footer. Data is concealed and displayed in different ways depending on the report element.

Report ElementResult when Folded

When a section is folded, section details are hidden and free cells only are displayed. In Reading mode, you can fold and unfold sections.

Table or Break

When a table or break is folded, the rows are concealed, and only headers and footers are displayed. Tables must have headers and footers to be folded and unfolded. Vertical tables, horizontal tables and cross tables can be folded and unfolded. In Reading mode, you can fold and unfold table or break


Log in to track your progress & complete quizzes