I want to analyze my sales by categories. Currently, I see a mapping between product and categories in catalog_Category_product table where multiple products are mapped with multiple categories. I want to mapped this table with sales_order_item so that i can create a table something like this.
parent cat | second cat| third cat | item_name| qty_ordered| order_id | base_price.
Thanks!
