Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
Adding catagory %'s in a Pivot
I have a pivot that I am trying to add %'s to data columns, Can anyone think
of a way this could be done? I have four columns across the top, each split into two sub-columns. I want to add a % for each of these sub-columns. In the example below, I have column one split by A and B. I would like to add that B is some% of the total A & B. I have this: 1 2 3 4 A B A B A B A B STATE I would like this: 1 2 3 4 A B % A B % A B % A B % STATE Each Main column has the %distribution of each sub-column. Thanks, ---bnpatten |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return data from catagory | Excel Worksheet Functions | |||
Second catagory axis in XY chart | Charts and Charting in Excel | |||
Transfer Per catagory | Excel Discussion (Misc queries) | |||
Catagory Axis | Charts and Charting in Excel | |||
I AM TRYING TO ADD INFO TO THE CATAGORY AXIS BUT IT WONT LET ME C. | Charts and Charting in Excel |