When i try to blend the order and address data source to do ananlysis.I found problems.
1. when the order as the primary data source(common data is the Last name):
total amount is 87294 this is the correct result because the date and total come from the order data source. and the country which from the second data source it appear the NULL and *.
2.when the address as the primary data source(common data is the Last name)
the total amount is 93504 which is incorrect.because the correct number should be 87294 and the date category appears the *.
Enclosed you will see all of the data and the project file.and also the pictures shows different.
what's the problem? Any ideas?