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

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.

--
~Chris

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

Excel 2007
Cumulative % for groups.
No Fruits.
Choice of four methods.
http://www.mediafire.com/file/euy2h1o5jyu/03_24_08.xlsx

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

Thanks, I'll play around with this and see what I can do.
--
~Chris

"Herbert Seidenberg" wrote:

Excel 2007
Cumulative % for groups.
No Fruits.
Choice of four methods.
http://www.mediafire.com/file/euy2h1o5jyu/03_24_08.xlsx