Product hierarchy - how to view all levels in a report?
I am trying to create a report which will show me all levels within a Product Hierarchy.
For example one of the Products may be "orders > amend order > change address > amend postcode (just as an example. Within my report I can add the Product hierarchy, but this appears as a drill down. What I want, is side-by-side columns to show orders > amend order > change address > amend postcode.
By choosing product_id, this just gives me the final Product value of 'amend postcode'
I need something like Product level 1, Product Level 2, Product Level 3 etc, side by side. Is this possible?