Hi Pieter

Thank you for thinking about this

Here is some sample data for Product A

InvtidCase_shipTrandateFiscYrPerPostweek_periodday_period

A10 1/1/21042014 1 1 1

A3 1/1/20142014 1 1 1

A50 1/2/21042014 1 1 2

A30 1/3/20142014 1 1 3

A20 1/9/21042014 1 2 2

A5 1/9/21042014 1 2 2

A 20 1/10/2014 2014 1 2 3

A 60 1/10/2104 2014 1 2 3

On 1/1/2104 I shipped a total of 13 cases

On 1/2/2104 I shipped a total of 50 cases

On 1/3/2104 I shipped a total of 30 cases

On 1/9/2014 I shipped a total of 30 cases

On 1/10/2014 I shipped a total of 80 cases

On 1/9 I shipped a total of 25 cases

I would like to show that in week 1 the maximum number of cases shipped on any day is 50 (1/2/2014)

I would like to show that in week 2 the maximum number of cases shipped on any day is 80 (1/10/2104)

I would also like to show that in perpost (monthh) 1 the maximum number of cases shipped on any day is 60 (1/10/2104)

Does this help a little?

Thanks

Tom