How the WPS table uses the pivot table

Source: Internet
Author: User

How to use a pivot table in a wps table:

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.