| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to hide and show a grouped column via VBA code? | Excel Discussion (Misc queries) | |||
| how to show repeating data in pivot table (not grouped) | Excel Discussion (Misc queries) | |||
| pivot tables -how do I show a percentage if I only have figures | Excel Discussion (Misc queries) | |||
| Pivot Chart - show 1 row value, but also showing percentage of who | Charts and Charting in Excel | |||
| Pivot table-show all grouped items | Excel Discussion (Misc queries) | |||
Linear Mode
