, and are still included in the summary. 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.
You cannot hide items in a selection-based set.
Right-click a row or column.
Click Hide.
Tip: To show hidden data, click the hidden link, and click Unhide(name of hidden item) or Unhide All.
You can also hide or unhide items by using the Properties pane.
