Creating a Product Delivery Summary

[Tobievr]

Hi All

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 would appreciate any assistance

Manifest	Description	Length	Width	Height	Product Dims	Qty	Total Volume Per Product
AA1000	Product 1	0,581	0,544	1,488	0,4703	40	18,812
AA1000	Product 2	0,581	0,544	1,488	0,4703	18	8,465
AA1000	Product 3	0,581	0,544	1,488	0,4703	10	4,703
AA1000	Product 4	0,722	0,816	0,928	0,5467	73	39,912
AA1000	Product 5	0,722	0,812	0,928	0,5441	22	11,969
AA1000	Product 6	0,661	0,644	1,653	0,7037	30	21,110
AA1000	Product 7	0,661	0,544	1,653	0,5944	15	8,916
AA1000	Product 8	0,661	0,544	1,653	0,5944	14	8,321
							122,208
	Manifest #	Total Qty	Total Volume
	AA1000	222	122,208

[Taoufiq_Zarra]

@Tobievr 

how to obtain 222 for total qty ?

Isn't that what you're looking for :

dimension :Manifest

Measure 1:sum(Total volume)

Mzasure 2: sum(qty)

?

[Tobievr]

Hi. 

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.

I know my explanation is not very good. 

Thanks

[Taoufiq_Zarra]

If I understood correctly :

you need a three-column table:

• Manifest
• sum(Total volume)
• sum(qty)

and how u get 222 for qty ?