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
|