further refine the results of report_hierarchy