Crosstable and impact with other measures

[antoinevunc]

I have a table with multiple dimension and measure

Example :

TABLE :
LOAD
     Date
     Dimension type product

     Amount Car
     Amount fruits
     Amount revenue boat 1
     Amount revenue boat 2
     Amount revenue boat 3

     Amount revenue boat 4

     Amount revenue boat 5
RESIDENT TABLE_TEST;

I created two new field Dimension_boat and sum product with cross table function, the problem is that the other measure are 5 times higher now, how is it possible to change this ?