Modify the SP_CONSOLIDATED_INVENTORY_VALUATION_REPORT and add Coordinate Group fields and filter for Coordinate Group and Extended Class in all of the hierarchy group filter and also create a new query that group by Coordinate Group then add on the SP_CONSOLIDATED_INVENTORY_VALUATION_REPORT