During analysis, the current selections are displayed above the sheet. Each current selections item has a small bar at the bottom that reflects the selection states for that dimension. Three states are displayed in the bars: selected (green), alternative (light gray), and excluded (dark gray). Locked values are indicated by a lock icon.
By clicking a current selections item, you can view, edit, or clear that selection in the popup that appears. You can also search for dimension values or lock the current selection. In the following image the selection menu is open. Depending on what selections that have been made previously, some of the options may not be available.
The following table describes the options.
| Select all | All values are selected (marked ). Alternative values change state to selected (green). Excluded values change state to selected excluded. They are still dark gray, but are now selected (marked ). If you clear the selections that made these values excluded, they will change state to selected (green). |
| Select possible | All possible values (white) are selected. |
| Select alternative |
When a selection has already been made in a field, alternative values, when present, have a light gray color. These are values that would have been possible values (white), if a selection had not already been made in that field. By selecting alternative values, the values that previously were selected, become alternative instead. |
| Select excluded |
If there are alternative values, they will be selected (green) and the values that previously were selected will change state to alternative. Excluded values will change state to selected excluded. If there are not any alternative values, the excluded values are selected (green), and the previously selected values change state to alternative. |
| Export data | Export the selected data to an Excel file. See Exporting data. |