I have a project to create a chart from multiple lists on SharePoint. But I'm not sure what is the best way to approach this requirement. We have a warehouse and shops in few cities. We've got one list containing the data of all the items that we store in the warehouse, the data is organized by product, quantity , date of purchase and date of delivery. We also have other lists of the shops (one list for each shop) containing the information of the salesmen and their personal achievement for each month(quantity items sales per day). What my boss wants is a chart that will show him each salesman's personal achievement from all the shops on monthly basis, and what percentage from the total quantity of items in the warehouse has s/he sold.
Any idea how shall I approach this requirement?
Any help will be much appreciated. Thank you in advance!