Current location - Quotes Website - Signature design - Ask God to solve the problems of excel PivotTable, and how to set row labels and column labels.
Ask God to solve the problems of excel PivotTable, and how to set row labels and column labels.
1. Select a data range. Under the Insert option of the PivotTable report, select New Worksheet as the location to generate the PivotTable report. Then, in the PivotTable field on the right, drag the field name of the business representative into the row, drag the company name into the column, and then drag it into the column.

2. Select the data range, and in the chart pivotchart under the Insert option, select the new worksheet as the location for generating the PivotTable report. Then, in the PivotTable field on the right, drag the field name Salesman into the row, drag the company name into the column, and then drag the sales amount.