View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
vbasean vbasean is offline
external usenet poster
 
Posts: 10
Default 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