Hide a Row or Column

You can hide rows or columns you do not want to show in a crosstab. For example, you may want to hide rows that contribute marginal values to the total.

The values of hidden rows and columns are included in the More & hidden subtotal, and are still included in the summary.

If you want to exclude the value from the More & hidden subtotal as well as hide the row or column from view, see Exclude Items.

Note: You cannot hide items in a selection-based set.

Procedure

  1. Right-click a row or column.
  2. Click Hide.
    Tip: To show hidden data, click the hidden link, and click Unhide (name of hidden item) or Unhide All.

    You can also unhide items by using the Properties pane.

Parent topic: Working With Items in the Crosstab