On the Pivot sheet, select the record(s) that you want to change the key states.
Select Change Key State or select Change Key State from the right-click menu.
The Change Key State dialog box is displayed.
Select the desired option from the Key
State drop-down list.
Click OK.
The records are colored according to the options selected. For example, a record
is highlighted with Green if A-Items is
selected as the key state for a record.
Click Cancel to cancel the action.
You can update the remaining rows once the Pivot sheet has been reloaded.
Note:
You must be an administrator to complete both tasks. You can use fast filtering in
the Phase Out Pivot sheet.
or select from the right-click menu.
The Change Key State dialog box is displayed.