kc.crow
Board Regular
- Joined
- Jul 7, 2005
- Messages
- 75
Hello
Have what seems to be an easy pivot table question that I haven't been able to get right. Below is my data
I am able to get the two numbers that I want to work with, but what I really need is (per distinct row header) the Count of Completed form divided by the Count of GID. So for the CB_CAT division on my example, I need to divide 2 by 437. I'm not getting this to work, though. Any suggestions?
Using Excel 2003
Thanks!
Have what seems to be an easy pivot table question that I haven't been able to get right. Below is my data
Excel Workbook | |||||
---|---|---|---|---|---|
B | C | D | |||
11 | Division | Data | Total | ||
12 | CB_CAT | Count of GID | 437 | ||
13 | * | Count of Completed Form | 2 | ||
14 | CIE | Count of GID | 2 | ||
15 | * | Count of Completed Form | * | ||
16 | Industry Automation | Count of GID | 1497 | ||
17 | * | Count of Completed Form | 85 | ||
18 | N/A | Count of GID | 311 | ||
19 | * | Count of Completed Form | 1 | ||
20 | Test | Count of GID | 5 | ||
21 | * | Count of Completed Form | 2 | ||
22 | CB_COT3 | Count of GID | 1100 | ||
23 | * | Count of Completed Form | 2 | ||
24 | TU_DEVELOP_PRODCHECK | Count of GID | 27 | ||
25 | * | Count of Completed Form | 3 | ||
PMP-EFA Forms Completed |
I am able to get the two numbers that I want to work with, but what I really need is (per distinct row header) the Count of Completed form divided by the Count of GID. So for the CB_CAT division on my example, I need to divide 2 by 437. I'm not getting this to work, though. Any suggestions?
Using Excel 2003
Thanks!