How the WPS table uses the pivot table feature

wps Table method of using Pivot table function

After entering the wps2016, find the location of the file, open the file that needs to be processed, enter the Excel main interface, and click the Insert button.

After clicking the Insert, click on the leftmost PivotTable report.

After entering the new interface, we can narrow the frame by clicking on the small icon on the way.

Click the left mouse button and drag the area we want to set. Here we have to deal not only with numbers but also with the content.

After the loop, in the input box will also show the corresponding table position.

Then go back to the interface, click on the bottom of the OK button.

At this point, the PivotTable field on the right side of the table, put all the content you want to calculate before the check mark.

If we are not asking for and, we need to click the inverted triangle in the option below, and then select the Value field setting in the bouncing frame.

Select the mode of operation we want to perform, sum or quadrature, or whatever, and then click on the OK button to go back to the interface just now.

We can see that the PivotTable report we set up is complete, and it's very convenient to compute it directly.