user008875 Member

Thank you! That makes much more sense. I appreciate your help.

Also, the order id has as many lines as it has different items.

I need to bucket the quantity of items per order, so I think I need a count of the sum. I have summed the number of items per order, but as it is a calculated field, it will not allow me to group (bucket) that, or at least I have not been able to figure that part out yet. Therefore, I end up with over 16,000 bars versus…