Home > database >  Percentage of Parent Total in Google Sheets Pivot Table
Percentage of Parent Total in Google Sheets Pivot Table

Time:11-12

I'm trying to find the percentage of the parent/category total in the below Pivot table. I manually calculated Column E to show what data I would like the Pivot table to return. Basically, I am looking for it to calculate the total percentage of each drink in a category based on the total number of drinks sold within that category.

Is this possible to do in Pivot Tables in Google Sheets? I know Excel has a % of Parent Total value but it doesn't seem like that is an option in GSheets. Is there is a custom calculated field that could be a work around for this?

enter image description here

enter image description here

  • Related