Group Parent Customers by similar attributes

[Anonymous]

Hi I have the following customer data table
https://docs.google.com/spreadsheets/d/177fbgW1Hvgs26UC0L0x2YLXhWAl0swbLL8T5jmM2IW0/edit#gid=0

Column 1 - Parent Customer ID

Column 2 - Specific Attributes of the software they are using

Column 3 - Number of users using that attribute

Column 4 - flag if the parent is using the attribute 1 yes 0 no

Is there an efficient neat way I can create groups of parents using the same attribute based on column 4?  I want to know how many different groupings I have, know which Parent IDs (Column 1) are in that group - so I can sum by column 3 or bring in other data for the groupings based on the parent IDs in that group.

[v-rongtiep-msft]

Hi @Anonymous ,

How about trying to use Matrix? Please  refer to the blog for more details.

Parent-child hierarchies 

If I have misunderstood your meaning, please provide a screenshot with your desired output.

How to Get Your Question Answered Quickly 

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

something like this?