K
kpritchett
I have a pivot table I've created in Excel from 120,000 lines in M
Access.
It's basically across time at the top level, with months from Jan t
Dec, starting:
January
Category A Category B
Person A 10 5
Person B 7 12
I need to get a running percentage contribution column for each MONT
from each category, ie a column next to Category A showing 67% (bein
10/15) and again next to Category B for 33%; without it being the tota
of that entire row.
Help!!
Access.
It's basically across time at the top level, with months from Jan t
Dec, starting:
January
Category A Category B
Person A 10 5
Person B 7 12
I need to get a running percentage contribution column for each MONT
from each category, ie a column next to Category A showing 67% (bein
10/15) and again next to Category B for 33%; without it being the tota
of that entire row.
Help!!