On the pivot sheet, select the records that you requires changing 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 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.
To cancel the action, click Cancel.
You can update the remaining rows once the pivot sheet is 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.