Assistance Required for Work Order Costing Report - Hierarchy & Overhead Differentiation

Hello,

We are developing a custom report titled "Work Order Costing Operation Wise." In our current scenario, the output of one manufacturing work order is being consumed as a component in another manufacturing work order.

When reviewing costs in the "Review Work Order Costs" screen, the system creates a cost hierarchy for that component item—breaking down its cost into Material, Resource, and Overhead components based on its manufacturing process. However, for our report, we do not require this detailed breakdown. Instead, we need the total cost of the component to be displayed as a single value under the Material column