Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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)
?
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
If I understood correctly :
you need a three-column table:
and how u get 222 for qty ?