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

[@TroyJScott]

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

[@ChrisMenardTraining]

Thanks, Troy. I'm with you. I'm always doing percentages.

[@TeresaR-ly4hx]

this saved my life-- thank you!

[@ChrisMenardTraining]

glad to be a life saver. :-)

[@Robert_512]

Good stuff! I have a Vandelay Industries t-shirt 😂

[@ChrisMenardTraining]

Thank you. Send me that T-Shirt. LOL

[@markwood6682]

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?

[@ahmedabdulahimahamud3272]

Perfect 🥰

[@ChrisMenardTraining]

Thanks.

[@vannyr6114]

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?

[@tutsecret499]

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

[@tutsecret499]

Does Pivot do statistics?

[@robinmcdonald1508]

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.