I am new to Odoo and seeking guidance on how to tackle a specific scenario. In our project, we have products, some of which are manufactured using raw materials. I want to calculate the total quantity of items used in a Bill of Materials (BOM) list, which can have nested BOMs.

For instance, let's consider a BOM for 'Project 1':

• Wall 1
  • Raw Material (r1) - Quantity: 2
• Wall 2
  • Raw Material (r1) - Quantity: 3
  • Raw Material (r2) - Quantity: 10

What I need is a view that displays the total quantity of items used in the BOM, as follows: BOM for 'Project 1':

• Raw Material (r1) - Total Quantity: 5 (summed from Wall 1 and Wall 2)
• Raw Material (r2) - Total Quantity: 10