Query based reporting is the easiest way to pull the actuals off each work order, but for the hierarchy, I am guessing you want something like the costs by system report (https://youtu.be/KVhzywE-4zQ?t=62&feature=shared) which shows the total dollars, so I think that gets you close and then you need a developer.
------------------------------
Christopher Winston
Projetech Inc.
IBM Champion 2024
------------------------------