Displaying a Constant Row or Column

Displaying a Constant Row or Column

You can display a constant value rather than the selected item. To do so:

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

   See Customizing Pivot Table Items.

2. Click Value.

3. Type a value into Value. For example:

   

4. Click OK.

You might also want to specify a different caption; see Specifying New Captions, later in this page.