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?