Changing the output type of the material report.
This setting is in Process output on the Output Ribbon.
Click the Output ribbon > Report Schemes > Process Output.
Then make sure you select Schemes and Materials > select the report you want to edit. Click Edit.
Then choose the Reports and Delivery tab, and click the material list Settings Edit button. Change the output type to All Levels Consolidated.
Click OK and then OK. Your report should be consolidated now.