Recently, the harem struggle more and more intense, which empress are not very hot, at the moment the royal dining Room and in the statistics of the fruit distribution of the Empress headache. Today I'm going to teach them a wonderful way to easily classify data, if you are in the normal work of the face of a large number of classified data, it will also count up a headache, feel the start, to learn the WPS Office 2012 of the PivotTable function bar, 1 minutes to easily count the data you want. If you don't believe it, look at it together!
I. Select a data region and 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
Two. Select Pivot Table Creation 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
Triple Recommendation: Click for free Download the latest version of WPS Office software "to see more computer tutorials
Three. 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
Figure 5
Click on the "Pivot table" button, a PivotTable report is done. As shown in Figure 5