mianmazher
Active Member
- Joined
- Jan 24, 2004
- Messages
- 412
Book1.xls | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
2 | Chemical Name | Formulation | Chemical Name | Formulation | Chemical Name | Formulation | ||
3 | PPG | 93.7 | PPG | 95.8 | PPG | 91.6 | ||
4 | TDI | 55 | TDI | 56 | TDI | 42 | ||
5 | H2O | 4 | MCL | 10 | MCL | 5 | ||
6 | Silicone | 1.2 | H2O | 5 | H2O | 2.5 | ||
7 | Tin | 0.15 | Silicone | 1.5 | Silicone | 1.25 | ||
8 | Amine | 0.2 | Tin | 0.25 | Tin | 0.3 | ||
9 | Color 1 | 2.1 | Amine | 0.13 | Amine | 0.22 | ||
10 | Color 2 | 2.1 | Color 5 | 2.1 | Color 1 | 2.1 | ||
11 | Color 3 | 2.1 | Color 6 | 2.1 | Color 2 | 2.1 | ||
12 | Color 3 | 2.1 | ||||||
13 | Color 4 | 2.1 | ||||||
14 | ||||||||
Sheet2 |
Book1.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Page1 | (All) | ||||
2 | ||||||
3 | Count of Value | Column | ||||
4 | Row | Formulation | Grand Total | |||
5 | Amine | 3 | 3 | |||
6 | Color 1 | 2 | 2 | |||
7 | Color 2 | 2 | 2 | |||
8 | Color 3 | 2 | 2 | |||
9 | Color 4 | 1 | 1 | |||
10 | Color 5 | 1 | 1 | |||
11 | Color 6 | 1 | 1 | |||
12 | H2O | 3 | 3 | |||
13 | MCL | 2 | 2 | |||
14 | PPG | 3 | 3 | |||
15 | Silicone | 3 | 3 | |||
16 | TDI | 3 | 3 | |||
17 | Tin | 3 | 3 | |||
18 | (blank) | |||||
19 | Grand Total | 29 | 29 | |||
Sheet1 |
I am making the Pivot Table using multiple consolidation But its showing the strange results instead of showing totals I think Its counting the number of entries
Plz help
Regards
Mian Mazher