Change Key State
- 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.