1 of 1 people found this helpful
Create a calculated field using formula -
Put this field into worksheet & go to "Edit Table Calculation". There in Advance section you have to use "Week of Ship Date" & "Product Container" in order.
Compute it at the level of "Week of Ship Date".
Is this provides you correct values? Let me know if this will not work.
Prashant beat me to the punch, with the correct answer. However I did want to mention you may not need to use advance computing, depending on what you really want to accomplish. Just setting the compute using Product Contain will give you: "Here I need to display min.Order Date as "1/2/2010" in all the rows for the Product container "Jumbo drum".
I am not at my workplace right now but I am not sure that without using advance computing it will provide min Order Date as "1/2/2010" for "Jumbo Drum". May be I am wrong.