Selections in pivot tables

In a pivot table, you make selections in the list that appears when you click a dimension item.

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 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.