Excel PivotTables Percentages - Grand Total, Parent Row Total, and Parent Total

PivotTables will save you a lot of time when doing complex calculations. Instead of having to use absolute reference, PivotTables will automatically do the percentage calculations for you. We will look at a variety of percentages in this video. We will use Percentage for Grand Totals, Percentage of Grand Total with 2 Rows, Percentage of Parent Row Total, and finally, Percentage of Parent Total.

Chapters:
0:00 Intro
0:15 Create and name Table
0:35 Create a PivotTable
1:30 Percentage of Grand Total
2:15 Percentage of Grand Total with 2 Rows
3:27 Percentage of Parent Row Total
5:00 Percentage of Parent Total
6:32 Closing Remarks

November 2022 YouTube videos published.
------

#chrismenardtraining #msexcel #Exceltraining #microsoftexcel #pivottables

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[TroyJScott]

I appreciate the Videos! I’m stuck with percentages weekly.

[Robert_]

Good stuff!

I have a Vandelay Industries t-shirt 😂

[markwood]

Hi Chris When you added the Dealership to the rows Excel automatically calculated the % of the Rep contribution in the Per of Row total without having to then go on to use the cool feature you demonstrated in the last column of data. I wonder what it would have calculated had you chosen the dealership option instead?

[vannyr]

Is there a way to only get a percentage from a total row from the grand total and have it not show to total 100% listing down the a single column?

[tutsecret]

Is that possible if you could provide the data file so I can practice? Thank you.

[robinmcdonald]

I get this error message and no matter how carefully I follow the instructions to fix the problem, the message comes back at me. The point is I haven't grouped anything to be ungrouped!!

'This pivot table report field. You cannot add a calculated item to a grouped field.

To ungroup this the field, make sure it is in the row or column area, select one of the items of the grouped field, click the Ungroup button in the Group group and the Analyze tab, and then insert the calculated item. After inserted, you can group the items of the field again.'


Clues as to what the issue is as I have no idea.