Total sum Customer1=Customer2

[#1]

Don't know how do to this. I want total Qty where Customer1=Customer2

Try sum({1} total <[Customer1]>=[Customer2]> Qty) but don't work

Thanks very much

[Table1]:
LOAD * INLINE [
Customer1, Prd, CA
001, A, 10
001, B, 20
002, A, 40
003, C, 100
];

[Table2]:
OUTER JOIN (Table1) LOAD * INLINE [
Prd, Qty, Customer2
A, 1, 001
B, 1, 002
C, 1, 003
D, 1, 001
E, 1, 001
];

[#2]

Hi

You expect then that Table2 entries without a corresponding Table1 entry will get Customer1 field set to Customer2 value?

Or summarise also when Customer1 is null?

Juerg

[#3]

Hi

Table 1 and Table 2 always correspond on field "prd"

thanks

[#4]

SomeBody to help me ?

Thank you very much

[#5]

Hi

You need to explain why you would expect the number 3 to show as your table has only 2 entries for Customer1 = 001.

You will get 3 for sum({1} TOTAL <Customer2> Qty)

And the {1} will ignore any selections you make - is this your intention?

Juerg

[#6]

Sorry, Here is a better exemple (Hope)

Thanks

[Table1]:
LOAD * INLINE [
Customer1, Prd, CA
001, A, 10
001, B, 20
002, A, 40
003, C, 100
001, A, 25
001, A, 45
];

[Table2]:
OUTER JOIN (Table1) LOAD * INLINE [
Prd, Customer2
A, 001
B, 002
C, 003
D, 001
E, 001
];

[martin59 · Accepted solution]

Hello,

You can try this :

count(Distinct if(Customer1=Customer2,Prd))

[martin59]

Here is my result :

[#9]

This is exactly what i want. Thank you very much