Hi i have four different files each containing a Customer name ,number and sales amounts ,each file is for a different quarter of the year ,i would like to join the four files so that i can produce a report which lists across the page by quarter the sales for each customer,however not all the customers with a sales figure in the first quarter(file,column) necessarily have an entry in any/all of the other three quarters(files,columns)
I cannot find a satisfactory method to join all 4 files so that i get all the information from each of the 4 files on my Report.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!