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.
You can apply sorts to the results displayed in section cells to organize the order in which sections display in report tables.
Sorting sections allows you to logically organize the section headers in a report.