Pivot Table Muliple Consolidation Abnormal behaviour

mianmazher

Active Member
Joined
Jan 24, 2004
Messages
412
Book1.xls
ABCDEF
2Chemical NameFormulationChemical NameFormulationChemical NameFormulation
3PPG93.7PPG95.8PPG91.6
4TDI55TDI56TDI42
5H2O4MCL10MCL5
6Silicone1.2H2O5H2O2.5
7Tin0.15Silicone1.5Silicone1.25
8Amine0.2Tin0.25Tin0.3
9Color 12.1Amine0.13Amine0.22
10Color 22.1Color 52.1Color 12.1
11Color 32.1Color 62.1Color 22.1
12Color 32.1
13Color 42.1
14
Sheet2
Book1.xls
ABCD
1Page1(All)
2
3Count of ValueColumn
4RowFormulationGrand Total
5Amine33
6Color 122
7Color 222
8Color 322
9Color 411
10Color 511
11Color 611
12H2O33
13MCL22
14PPG33
15Silicone33
16TDI33
17Tin33
18(blank)
19Grand Total2929
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
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
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

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
Hi:

Is this what your expected results should look like??
Book1
DEFGH
21
22Page1(All)
23
24Sum of ValueColumn
25RowFormulationGrand Total
26Amine0.550.55
27Color 14.24.2
28Color 24.24.2
29Color 34.24.2
30Color 42.12.1
31Color 52.12.1
32Color 62.12.1
33H2O11.511.5
34MCL1515
35PPG281.1281.1
36Silicone3.953.95
37TDI153153
38Tin0.70.7
39Grand Total484.7484.7
40
Sheet3


plettieri
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,896
Messages
5,766,992
Members
425,392
Latest member
Booknerd

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top