Create a report using ... the pivot table creation process in the new sheet. In the PivotTable Fields area, the first field you select will be the reference field. In this example, this pivot ...