Hey,

I have a problem with this pivot table i'm trying to create.

The context relateds to printing machines market. It is about the analysis of market shares (%) of 9 companies in Austria and Belgium. Each country is characterised by a Total of Units ('Tot.U.') that represents the size of the market.

Data source

Country Tot.U. Company Share Units
Austria
40000
a 16,5 6600
b 0 0
c 0 0
d 10,9 4360
e 16,1 6440
f 0 0
g 32,9 13160
h 23,6 9440
i 0 0
Sum 100 360000

Sum 100 360000

Belgium
93744
a 31 29060,64
b 1 937,44
c 6 5624,64
d 20 18748,8
e 17 15936,48
f 9 8436,96
g 16 14999,04
h 0 0
i 0 0
Sum 100 843696

Sum 100 843696

Gr. Sum 200 2407392

Where: 'Units' is an inserted field whose formula is: 'share'/100*'Tot.U.'

Question

Why is the Sum of 'Share' within a country correct (=100) whereas the sum of 'Units' is not correct? Indeed the latter is in fact equal to 9 (the number of companies) times the total of the units listed for a country.

I have a feeling that the problem is due to the way I have organised my data source. Indeed, the table is not a perfectly crossed one: the field 'Unit' relates in fact only to the field 'country' (it's a hierachised field, kind of).

How can I fix this?

Could anyone help me, thank you, I appreciate!!!

xavier