WPS2012 PivotTable reports to easily resolve statistical challenges

If you are in the normal work of the face of a large number of classified data statistics can not feel, may want to learn the WPS Office 2012 PivotTable report function, a minute to easily statistics the desired data.

Select a range of data to create a PivotTable report

After opening the WPS table, first select the data range to be counted with the mouse box, click "Insert" in the second tab on the left of the toolbar above the table, and then choose the first button "PivotTable" On the Insert tab. As shown in Figure 1

Figure 1

Choose a pivot table to create a location

When you click the PivotTable button, pop up the Create Data dialog box and select the position of the PivotTable report at the bottom of the dialog box, we can create the table on the current worksheet or create it on a new worksheet as needed. Then click "OK". As shown in Figure 2

Figure 2 Computer Tutorials

Third, set up a PivotTable report

To set the pivot table on the right side of the worksheet, we can drag the fields in the field list to the PivotTable area one by one, depending on the needs of the table. For example, we can. Drag the product field to the column area, drag the Customer field to the row area and drag the Total Price field to the data area as shown in Figure 3

Figure 3

Figure 4

Click on the "Pivot table" button, a PivotTable report is done. As shown in Figure 5

Figure 5