• Hi Lowell

    Thank you very much for looking at this and cleaning up my data. Please excuse my naive question that I am about to pose.

    Am I correct that with your query I will be be creating a new dataset that operates at the "day" level instead of the "order" level that is currently the lowest detail level?

    If so, is there no way to accomplish this from within the current report builder format as I can see the daily sums of shipments I "just" need to determine the max.

    I fear that my novice report builder level is on display here

    Thanks again

    Tom