Hierarchy

CommunityMember113484
CommunityMember113484
in Modeling

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

Tagged:

Answers

  • Puneeth H P
    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 

    Success is the Intersection of Dreams and Hardwork!

  • AlejandroGomez
    AlejandroGomez

    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.

     

Categories