I believe this probably a very easy question to all of you but I don't really know how to do because the output is not what I want.
I have a Sales Table, Customer Table and a Sales Revenue Table. I tried to link these up, looks easy but I couldn't get what I want after.
Anyone can help me a bit?
Please refer to the attached qvw file.
Problem: A dedicated salesperson will look after a customer but another salesperson can do business with other customer as well. In such case, I would like to see how much sales amount of a customer to the company and by whom. I linked up all table and create a pivot table, found that if the sales is not done by the responsible salesperson, the customer's name unable to be shown. How can i solve this? any problem with my tables structure?