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 |
All times are GMT +1. The time now is 10:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com