I have 3 content types that I have created: order, product and salesperson.
The fields for each are as follows: Order: Purchaser Name, Product (entity reference to Product), Quantity Product: Product Name, Salesperson (entity reference to Salesperson) Salesperson: Name, Email
The way the system works is that a salesperson creates a product and then sells that product. Each product will be tied to a salesperson (no other salesperson can sell that product). Once they receive an order, they would create "content" containing the name of the person buying the product, what product it was, and the quantity they sold.
I'm trying to figure out how to create a view that would let me allow a user to choose a product and have the view show how many of that product were sold.
Did I set this up the right way using 3 different content types with entity references or is there a better option? If so, how can I show the sum of all the orders tied to a certain product?