Specifying a Spacer Row or Column

Specifying a Spacer Row or Column

You can display a spacer row or column rather than the selected item or items. To do so:

1. Click the Advanced Options button next to the item.

   See Customizing Pivot Table Items.

2. Click Space.

3. Click OK.

The following shows an example:

For this pivot table, the Rows definition is as follows: