Product hierarchy - how to view all levels in a report?

Content

Hi everyone

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?