In a pivot table, you can make selections either by clicking on dimensions in the table, or by making a selection in the list that appears when you click a dimension item.
Selecting dimension fields in the table
You can make selections in a pivot table by clicking or drawing in the dimension fields. Measure values cannot be selected. When you make a selection, it is always the dimension values that you select. You can only make selections for one dimension at a time.
To deselect a row, click it. To confirm a selection, click or click outside the visualization. You can also press Enter. To cancel, click or press Esc. If you confirm, the selection is reflected in all visualizations associated with the pivot table.
You cannot select dimension values that are NULL. Null values in a table are presented as dashes (-).
Selecting dimension list items
The list displays the values from the chosen dimension. You can select fields by clicking or by drawing. All selected fields are marked green. To deselect a field, click it. To confirm a selection, click or click outside the visualization. You can also press Enter. To cancel, click or press Esc. If you confirm, the selection is reflected in all objects related to the pivot table.
You cannot select dimension values that are null. Null values in a pivot table are presented as dashes (-). Rows without valid dimension values will not be included in the selection.