Crosstable and impact with other measures

antoinevunc — Wed, 20 Jun 2018 21:40:43 GMT

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 ?

topic Crosstable and impact with other measures in App Development

Crosstable and impact with other measures