Like and see, form a habit; Every man is responsible for the rise and fall of the world.
Wechat search [Yixin Excel] to pay attention to this different we-media person.
In this paper, making github.com/hugogoos/Ex… Has been included, including Excel system learning guide series of articles, as well as a variety of Excel materials.
How do you add a growth value to the PivotTable?
This problem involves two issues, one is how to add fields to the PivotTable and the other is how to calculate the difference.
Looking directly at the processing results and source data, let’s go into detail on how to add the difference between the current month and the previous month to the PivotTable.
First select the data A1:C13 cell area and click PivotTable in the Table command group under the Insert TAB.
You can either create a new worksheet or select an existing worksheet, which is new in this case.
Then we can directly check the PivotTable field. When we check the PivotTable field, we find the name, month, and value.
Obviously this structure is not what we want, we want to display the month in a column, so we can left-click the month in the row area and select move to the column TAB.
Now we can try to add growth fields by clicking fields, Items and Sets in the Calculate command group under the Analyze TAB and selecting Calculate Fields to bring up the Insert Calculate Fields dialog box.
In the insert calculation field dialog box you can add a field, you can enter the value of the new field in the formula how to calculate.
As shown in the figure above, we found a problem. We wanted to calculate the sales difference between two months, but there was only one sales, so the field could be added, but the difference could not be calculated. The display method was not good.
I don’t know if you remember in the beginning when you checked PivotTable fields you had a row area, a column area, a value area. The value field is mainly used to store sales data. We can drag the sales field directly to the value field.
We can see that there are two sales columns below each month, and the values are the same. At this point we can left-click “Sum item: Sales 2” and select “Value Field Settings” to bring up the value field Settings dialog box.
We can customize the name: increase from last month. Then select the Value Display mode TAB and select Differences.
Then select Month for Basic Field, and select (Previous) for Basic Item. The PivotTable changes as follows:
Last-column totals, or last-row totals, can be set by enabling rows in the Total drop down list in the Layout command group under the Design TAB, so we only keep row totals here.
Once we’ve done this, we have our desired growth data, but the table doesn’t look pretty. We can beautify it by selecting some of the style templates provided in the PivotTable Styles command group under the Design TAB.
Of course, after the completion of beautification may still not be satisfied, then you need to adjust yourself. The image below shows what a style template looks like.
You can see that there is still some gap between the aesthetic and the renderings I gave at the beginning, and then there is the problem of adjusting the style. I will not elaborate on the adjustment steps here. Take a look at the main operation dynamic diagram:
Beautify the PivotTable action diagram:
Today’s sharing ends here, but the road of learning has just begun, I hope we can keep moving forward on the road of learning, perseverance.
If you are interested in the feature, you can tell xiaobian oh, xiaobian will write a corresponding article for you. Of course, it’s first come, first written. I will make a schedule and try to meet everyone’s needs. So if the next article is not what you want, please don’t worry, it may be the next one. Let me know what you want to learn.
This article continues to update, you can search wechat “yixin Excel” first time to read, this article GitHub github.com/hugogoos/Ex… Excel System Learning Guide series, welcome Star.