Home > Topics > excel > body text

Excel pivot table learning value field settings

青灯夜游
Release: 2022-04-24 10:24:37
forward
13149 people have browsed it

In the previous article "Practical Excel Tips Sharing: Using Pivot Tables to Summarize Performance", we learned about Excel Pivot Tables and how to use Pivot Tables to summarize performance. Today we continue to learn Excel pivot tables and talk about value field settings. I hope it will be helpful to everyone!

Excel pivot table learning value field settings

At the end of the previous pivot table tutorial, I leave a small question for my partners: How to adjust the implementation department according to the first, second and third departments of the pivot table on the left below? Partially sorted, the effect is as shown on the right.

Excel pivot table learning value field settings

There is no pivot table sorting here. Drag the cells directly in the pivot table to change the arrangement of departments. Please watch the picture below for the animation operation:

Excel pivot table learning value field settings

Today is the second section of our pivot table tutorial: value field settings.

1. Where is the value field set?

In the pivot table---right-click---display the field list, the "Pivot Table Fields" dialog box appears. Click "Values" and then select "Sales Performance" - select "Value Field Settings".

Excel pivot table learning value field settings

#2. What is the function of value field setting?

Change the value summary method, such as sum, count, maximum value, average value, minimum value, etc.

The pivot table defaults to summation. We can implement counting and other summary methods through settings.

3. Case demonstration value field setting operation

The following is the sales performance data table of each department:

Excel pivot table learning value field settings

Through the pivot table, use the value field settings to quickly calculate three questions:

  • Sales performance summary of each department

  • What is the highest performance of each department

  • What is the lowest performance of each department

The pivot table statistical results are as follows:

Excel pivot table learning value field settings

The following is a demonstration of the operation steps:

Excel pivot table learning value field settings

Related learning recommendations: excel tutorial

The above is the detailed content of Excel pivot table learning value field settings. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:itblw.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template