When constructing a pivot table, selecting the columns to drag and drop in to the Filters, Column Fields, Row Fields or Data Fields should be multi select.
Agree, it would be useful