How to do subtotals in Microsoft Excel 2020 Pivot Tables How to do subtotals in Microsoft Excel 2020 Pivot Tables

Want to know how to use pivot tables for subtotals in Microsoft Excel 2020? PHP editor Zimo will introduce in detail how to use this powerful function to help you easily organize, summarize and analyze your data. Continue reading this guide for step-by-step instructions on creating subtotals, custom groupings, and using various summary functions.

1. First, we need to select [Data Pivot Chart], as shown in the figure below.

2. Then select the area and [OK] to create a pivot table, as shown in the figure below.

3. After the production is completed, you can see all the items on the right, and check the items that need to be displayed, as shown in the figure below.

4. To perform classification and summary, we need to drag the corresponding entries into [Row] or [Column], as shown in the figure below.

5. For example, here we want to summarize who is in each class, so drag the class and name into [row], as shown in the figure below.

6. At this time, you will find that the name is in front of the class, so we move the class above the name, as shown in the figure below.

7. After dragging is completed, the classification and summary will be completed, as shown in the figure below.

The above is the detailed content of How to do subtotals in Microsoft Excel 2020 Pivot Tables How to do subtotals in Microsoft Excel 2020 Pivot Tables. For more information, please follow other related articles on the PHP Chinese website!