Column Dimensions

The column dimension area appears directly underneath the slicer dimension area (see Slicer Area (Table View)). The members of the column dimension appear on the column headers along the top of the data area. The column dimension members are the same color as the column dimension tile.

Any dimension can be placed in the column dimension area. You can have more than one column dimension by nesting one dimension inside another.

You can move and nest dimensions in either of the following ways:

• Drag and Drop one dimension tile onto or next to another. Dimension tiles have a textured area for dragging.
• Use the Rearrange report dialog to arrange dimensions without dragging and dropping. (Click Table options> Rearrange report, or select View menu > Table options > Rearrange report.)

The name of the column dimension appears in the column dimension tile.

• Dimension names are underlined to indicate that they are clickable. Clicking a dimension name opens the dimension definition page for the dimension.

The names of the column dimension members appear in the column headers, across the top of the data area.

• If the name of a column dimension member is underlined, it means that the member represents a group. To drill into the group and view its members, click on the underlined member name. (To drill back up, use your browser's "Back" button.)

If a dimension or a dimension member has summary information associated with it, an "Info" icon appears after its name. You can click the icon to view the summary.

If a column dimension or dimension member has footnotes, footnote symbols appear in brackets after its name. You can hover over the footnote indicator with your mouse cursor to read the footnotes in a pop-up.

The following symbols appear in column headers:

• Sort Arrows . Click on the arrows to sort by the values in the column.
• Rank icon . Click to apply ranking to the values in the column.
• Top/Bottom Reduction icon . Click to apply Top/Bottom Reduction, which enables you to limit your data to selected values at the top or bottom of the data range.Also see Applying Top Bottom Reduction.