Changing a key state

On the pivot sheet, select the records that requires changing the key states.

Select Change Key State

or select from the right-click menu.

On Change Key State, select an 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.