Skip to Content
avatar image
Former Member

Hana calculation view wrong aggregation between joins

Hi everyone,

I have the following issue i have a join between two projections, the thing is on the left table i have a measure wich duplicate many times as number of LGORT or CHARG for each material. I want the measure of the left fixed for one material independent of LGORT AND CHARG not aggregate by the dimensions of the right table.

if i dont use anything of the rigth table the measure its correct but if i include a measure of the right make the sum for all values of CHARG and LGORT

11.jpg (48.7 kB)
12.jpg (47.0 kB)
13.jpg (11.6 kB)
11.jpg (10.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers