cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Totaling a Hierarchy Split Across Multiple Data Sets

I am reporting on hierarchical data. The hierarchy has five levels.  I have five data files, one for each level of the hierarchy.  Each line of data has a parent id which connects that line of data to the parent item which is one level higher in the hierarchy.  Each line of data also has a point value which is the sum of its child point values.  I'm trying to find the point value of the items at the top level of the hierarchy by summing the total of all child (and all grandchild) items.  Something like this:  

 
Level 1 Item     24
 Level 2 Item    12
  Level 3 Item   6
   Level 4 Item  1
     Level 5 Item1
   Level 4 Item  1
     Level 5 Item1
   Level 4 Item  1
     Level 5 Item1
  Level 3 Item   6
   Level 4 Item  1
     Level 5 Item1
   Level 4 Item  1
     Level 5 Item1
   Level 4 Item  1
     Level 5 Item1
 Level 2 Item    12
  Level 3 Item   6
   Level 4 Item  1
     Level 5 Item1
   Level 4 Item  1
     Level 5 Item1
   Level 4 Item  1
     Level 5 Item1
  Level 3 Item   6
   Level 4 Item  1
     Level 5 Item1
   Level 4 Item  1
     Level 5 Item1
   Level 4 Item  1
     Level 5 Item1
 

What is the best way to accomplish this?  

1 ACCEPTED SOLUTION
v-frfei-msft
Community Support
Community Support

Hi  @Anonymous ,

 

You can use matrix visual to work on it.

Capture.PNG

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

2 REPLIES 2
v-frfei-msft
Community Support
Community Support

Hi  @Anonymous ,

 

You can use matrix visual to work on it.

Capture.PNG

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

jborro
Solution Sage
Solution Sage

Hi @Anonymous

Would it be by merging files one by one from the top to the lowest child file and then group?

Kind regards,
JB

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors