I have two channels, one called Product System (product_system) and one called Product Orders (product_orders). The product system contains all the products that the company produces and the product orders contains all the products ordered in a particular order. The two channels are linked by product_id relationship field in product_orders.
What I want to be able to do is to produce a product order spreadsheet, that allows me to show the orders in rows, the products in columns and the number of products ordered, in a particular order, in the related square in the grid.
The columns must be dynamic, so that if a new product is added, it automatically appears in the grid.