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 m or click outside the visualization. You can also press Enter. To cancel, click E 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 m or click outside the visualization. You can also press Enter. To cancel, click E 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.