HDI: Show Value as 'Percentage of' Grouped Column in Pivot

V

vbasean

I have a pivot table with a grouped by column

Fruits Vegitables
Apples Oranges Pinapples Carrots Celery Onions Total Percentage
11.11% 17.78% 20.00% 33.33% 11.11% 6.67% 100.00%

I need my percentage by Top grouped column.

Like this:

Fruits Vegitables
Apples Oranges Pinapples Carrots Celery Onions
22.73% 36.36% 40.91% 100.00% 65.22% 21.74% 13.04% 100.00%

Also, my groups are manually grouped.

Thanks in advance for any help.
 
Top