I am facing an issue with creating a report that consolidates the total sales volume in kilograms.

1. I have already specified the weight for each product.
2. I have also aggregated the total sales quantity.

The key question is: how can I create a report that multiplies the weight by the quantity for each item, as shown in the attached image?

Let me know if you need further.