Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
];
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
Hi
Table 1 and Table 2 always correspond on field "prd"
thanks
SomeBody to help me ?
Thank you very much
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
Hello,
You can try this :
count(Distinct if(Customer1=Customer2,Prd))
This is exactly what i want. Thank you very much