Pivot Table Muliple Consolidation Abnormal behaviour

[mianmazher]

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

 

[mianmazher]

Hi All forum Members


Still waiting fo help


Regards

Mian Mazher

 

[plettieri]

Hi;

Are the items in question numbers (not text)?

Are you choosing sum ...and not count in the PT options for that field?

hope this helps
plettieri

 

[plettieri]

Hi:

Is this what your expected results should look like??

Book1
	D	E	F	G	H
21
22		Page1	(All)
23
24		Sum of Value	Column
25		Row	Formulation	Grand Total
26		Amine	0.55	0.55
27		Color 1	4.2	4.2
28		Color 2	4.2	4.2
29		Color 3	4.2	4.2
30		Color 4	2.1	2.1
31		Color 5	2.1	2.1
32		Color 6	2.1	2.1
33		H2O	11.5	11.5
34		MCL	15	15
35		PPG	281.1	281.1
36		Silicone	3.95	3.95
37		TDI	153	153
38		Tin	0.7	0.7
39		Grand Total	484.7	484.7
40
Sheet3

plettieri