I'm having difficulty figuring this one out. I have records like this

Item no     Piece/carton     Total pieces     Cartons/Skid (calculation)
Z44377-1--     400            16800             42
Z44377-1--     400            16800             42
Z44377-1--     400             4400             11
Z44377-1--     400             8800             22

and I want output of

Z44377-1--                    
2 skid @ 42 ctn @ 400 pcs/ctn   33,600 pcs
1 skid @ 11 ctn @ 400 pcs/ctn    4,400 pcs
1 skid @ 22 ctn @ 400 pcs/ctn    8,800 pcs
                    
                                               46,800

Ideally I would like to group on a concatenation of item no, pieces/carton and cartons/skid so I could do a count of records (number of skids) and sum the pieces. Can you group on a concatenation? Any ideas how I can accomplish this?

Thanks!

I work in a warehouse. We have a system that holds records for each skid of an item. We submit a daily report to our customer of the inventory of each item. We need to sum it up by same skid configurations. For example the output that I'm looking for that I listed would tell them that we have 2 full skids @ 16,800/skid + 1 partial skid at 4,400 and 1 partial skid at 8,800 for a total of 46,800 pieces.

If I'm reading the response right I'm not trying to display unduplicated data because there is a record for each skid.

Does this make sense?

Yes you are correct. I do not know if a skid is full but as long as I combine "like" skids that all they need to know.

One thing I failed to say but you might have guessed is that the skid tag (each skid) is unique key of the file. The database is weird. There is a field for pieces per carton and a field for total pieces but nothing for number of cartons. That's why I have to calculate it.

This is the email they send out now. They manually go into the system for each item and have to add it up.

60090 Fusion
40 pallets – 48 ctns @ 90 pcs/ctn

61146 Imperial
3 pallets – 32 ctns @ 100 pcs/ctn
1 pallet – 23 ctns @ 100 pcs/ctn

61193 Lutron
1 pallet – 36 ctns @ 400 pcs/ctn

61196 – 5059298 Lutron 400-3497 Rev A CRB
2 pallet – 42 ctns @ 400 pcs/ctn
1 pallet – 11 ctns @ 400 pcs/ctn
1 pallet – 22 ctns @ 400 pcs/ctn