Hierarchy

CommunityMember113484

Hi,

I have a list of products, with Country as Parent. Each product also belongs to a specific reporting group (which I've included as a line item in a Product Details module).

I need to create a report which is categorised by reporting group (with products under each).  However, looks like you can only have 1 parent? Is there a way around this?
Thanks

Puneeth H P

Hi @CommunityMember113484 

 

You can create Flat Reporting Group list and in product details module line item with Reporting Group list formatted you can assign same group for many products and reference this to categorize in Reporting module by LOOKUP of the Reporting group which is dimensioned by the Product list . You will get Country as well as a parent of the list . 

 

Thanks,

Puneeth HP