then choose the one you want to add to the report sheet. Create a report with pivot tables: Select Insert > PivotTable. Select the data range you want to analyze in the Table/Range field.