How Excel PivotTable reports use

Source: Internet
Author: User

1. Open the Excel table you want to summarize and click on the PivotTable report

2. The PivotTable report data source selection, select the data you want to determine, you will see the PivotTable reports options

3. Will you need the report field, with the left mouse button to live, drag into the right row coordinates and numerical area

4. In general, we do the data rollup is the sum of data, or to find the average and so on, so we need to modify the field of the value range. Select the small triangular line behind the field and click on "Value field settings" To change the calculation type to "sum" or whatever you need.

5. After the confirmation closes the report, the summary result comes out.

6. If you also want a sales summary of each product for each business, you can also add a row label. The mouse is placed in the row and column, right click, display the field list, the customer name to the line tag.

7. Such a table does not seem to be very accustomed to, you can put the mouse in the "Customer name", click Right, change "field settings", in the layout and printing, select "Show item label in tabular form". If the data is changed, click the right mouse button on the PivotTable report, and click Refresh.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

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: and provide relevant evidence. A staff member will contact you within 5 working days.