Hierarchy

Highlighted
Occasional Contributor

Hierarchy

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

2 REPLIES 2
Highlighted
Frequent Contributor

Re: Hierarchy

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 

Highlighted
Certified Master Anaplanner

Re: Hierarchy

as an alternative to the solution given by @Puneeth H P , you can also assign a Reporting Group to each product as a property and then use SUM to report numeric values at the Reporting Group Level. 

 

AlejandroGomez_0-1603280001689.png

AlejandroGomez_1-1603280086806.png

 

Please, note that best practice is to store values and properties in a module rather than in a list, but the SUM function in the report module will follow the same logic.