0:00
In this video, we will learn how to
0:01
change the way data is aggregated in a
0:03
pivot table in Excel 365. This is
0:05
especially useful when you need to
0:07
summarize large sets of data more
0:08
effectively based on different criteria.
0:11
After creating a pivot table, you may
0:13
want to modify how the data is
0:15
calculated or displayed to better suit
0:16
your analysis. For example, if you are
0:19
working with numerical data, the default
0:21
aggregation is usually set to sum.
0:23
However, you can easily change this to
0:25
other types of calculations depending on
0:26
what insights you need. To do that, go
0:29
to the value section of the pivot table.
0:31
Click the drop-own arrow next to the
0:33
value field you want to change. Here you
0:35
will find several options such as count,
0:37
average, max, and more. Selecting one of
0:40
these will immediately change the
0:41
calculation method used in the table.
0:44
This gives you the flexibility to adjust
0:45
the summary format according to the
0:47
needs of your report. Additionally, if
0:50
you want to analyze the data from a
0:52
different perspective, you can drag a
0:54
field-like region into the rows area.
0:56
This allows you to break down the data
0:58
by region and count or sum other values
1:01
accordingly. For instance, placing
1:04
region into rows and adjusting the value
1:05
field to sum will help you see the total
1:07
for each region clearly. You can also
1:10
filter the data in the pivot table to
1:12
compare different segments more easily.
1:13
By changing the structure and the
1:15
aggregation method, your analysis
1:16
becomes more dynamic and tailored to
1:18
specific goals. Mastering these simple
1:21
steps will make your work in Excel more
1:22
efficient, especially when dealing with
1:24
complex or large data sets that require
1:26
various ways of summarizing the
