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 ?