How to add subtotals in Excel Pivot Table (remove subtotals and grand total,Row Labels on same line)
After converting an Excel table into a pivot table, it is very convenient to subtotal, just check the classification field and the field to be subtotalled, and Excel will automatically subtotal the number of different classifications.
Chapters:
0:00 How to add subtotals in Excel Pivot Table?
0:27 How to remove subtotals from Pivot Table Excel?
0:53 How to remove grand total from Pivot Table?
1:14 How to make Row Labels on same line in Pivot Table?
Description:
How to add subtotals in Excel Pivot Table (remove subtotals and grand total,Row Labels on same line)
Subtotals can total either one field (one column) or multiple fields at the same time. In addition to subtotal, pivot tables will also automatically total, but some fields do not need to be subtotalled, and we want to cancel the totals, and pivot tables also provide this feature, so subtotals should be the case. In addition, the pivot table folds the row labels into one column by default, that is, all the row labels are displayed in one column, which is sometimes not convenient for analysis and statistics, so it is required to display them side by side, and the pivot table also provides this feature.
One. How to add and remove subtotals in Excel Pivot Table?
(1) How to add subtotals in Excel Pivot Table?
1. A clothing sales table is divided into men's clothing and women's clothing, and there are sub-Classifications under the Classifications, that is, men's clothing is divided into T-shirts and shirts, and women's clothing is also divided into T-shirts and shirts.
2. Steps: check the "Classification1" first, and then check the "Sales", then the total sales of men's and women's clothing will be subtotalled, and then check the "Classification2", then the total sales of "T-shirts and shirts" under "Men's Clothing" and "T-shirts and shirts" under "Women's Clothing" will be subtotalled.
(2) How to remove subtotals from Pivot Table Excel?
1. Method 1: Right-click "Men's Clothing" and select "Subtotal "Classification1"" in the pop-up menu, then the Subtotals of "Men's Clothing" and "Women's Clothing" will be canceled.
2. Method 2 (Another way):
Select any cell of the pivot table (such as A4), select the "Design" tab, click "Subtotals" in the top left of the screen, and select "Do not show Subtotals" in the pop-up menu, then the subtotals of "Men's Clothing" and "Women's Clothing" will be canceled.
Two. How to remove grand total from Pivot Table?
1. Right-click any cell of the pivot table (such as A3), select "PivotTable Options" in the pop-up menu, open the "Pivot Table Options" window, select the "Totals and Filters" tab, leave Show grand total for rows" and "Show grand total for Columns" unchecked, and click "OK", then "Grand Totals" will be canceled.
2. If you only want to cancel the "Show grand total for rows", you can leave it unchecked; Which should be the case for "grand totals for columns".
Three. How to make Row Labels on same line in Pivot Table? (pivot row labels on same line, Multiple row labels of Excel pivot table are displayed side by side)
1. Right-click any cell of the pivot table (such as A4), select "Pivot Table Options" in the pop-up menu, open the "Pivot Table Options" window, select the "Display" tab, check "Classic PivotTable Layout (enables dragging of fields in the grid)", click "OK", then all row labels will be displayed side by side.
2. Set a style for the table
Select one of the pivot table cells (such as B5), select the “Design” tab, click the "One Horizontal + Down Arrow" icon in the upper-right corner of the "Pivot Table Styles", and select "Light Orange, Pivot Style Medium 3 "in the panel that is popped up, .
3. After displaying the row labels side by side, there is a "Filter" icon on the right side of each row label, which can be used to sort, label fiters, value fiters, and search.
Watch video How to add subtotals in Excel Pivot Table (remove subtotals and grand total,Row Labels on same line) online without registration, duration hours minute second in high quality. This video was added by user Loinsure 13 March 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 351 once and liked it 5 people.