Hi

I was able to find a solution thanks to the prodding by Lowell and Pieter

I built a new dataset in report builder using the same table as before but tried out the "Group and Aggregate" function and for the case_ship field I chose "Sum" as my aggregate.... In essence this gave me a very cool and easy daliy sum of the shipped cases.

When I used this new dataset and built my matrix report I was able to easily get the max daily shipment for each product by week, month and year.

Tom