I am stuck with the below calculation. I have data coming at a single product level (Per Parcel). Each Parcel has specific dimensions. I need to be able to consolidate the dimensions into a single line total. Below is a table I created to try explain the layout and end result. If I work it out in Excel, I get the correct final total.
The end result must be a single consolidate row in Red Below.
It is probably very simple solution, but I have tried everything to get to that total and cant.
I dont have last 2 columns data. I have a per product dimension and a count of parcels for each product and I am looking for the formula that will Consolidate the 3 dimensions, multiply it by a parcel count to get a volume per product and then sum all of it to get the end result.