Dividing data into sections

For example, you have a list that shows products that were purchased. For each product, the product type is also shown. You section the product type column to show a separate list for each product type. The product type is displayed as the heading for each list.

Creating sections is similar to grouping data. The difference is that when you create sections, a separate list, crosstab, visualization, or chart is displayed for each data item and a section header is displayed outside the list, crosstab, visualization, or chart. In addition, you can group data items only in lists but you can create sections in lists, crosstabs, visualizations, and charts.

For dimensional data, you can also create page layers to show values on a separate page for each member.

When you remove a section, the data item is returned to the original list, crosstab, visualization, or chart. For crosstabs, if you created sections for both rows and columns simultaneously (with Ctrl+click or Shift+click), when you remove the section, all data items are returned to one edge of the crosstab for the first data item that you selected. For example, you Ctrl+click the rows and then the columns, and you create a section. When you remove the section, all data items are returned to the rows. You can then drag the data items that belong in the columns back into the Columns area.