| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
% of Subtotal in PivotTable
Hi All -
I have an ongoing question that I have been unable to find an answer to for several months now and am looking here as a last resort. Is there a way to create a data column in a pivottable that would match the description of a % of column subtotal? Say I have a pivot table that looks like: --------------- Field 1 Field x 1 Field y 2 Field z 3 Field 2 Field x 4 Field y 5 Field z 6 And I would like to create a second data column that would calculate the percent of column for each of Field 1 and Field 2 --------------- Field 1 Field x 1 .167 Field y 2 .333 Field z 3 .500 Field 2 Field x 4 .267 Field y 5 .333 Field z 6 .400 Is this possible? Thanks everyone! -- cmungs |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a PivotTable w/o selecting data in an existing PivotTable | Excel Discussion (Misc queries) | |||
| pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
| Bolding the subtotal lines automaticlly When using the Subtotal fu | New Users to Excel | |||
| copy subtotal value only, subtotal value can be vlookup by others | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Threaded Mode
