system should pick pgi quantity not shipped qty

Hi,

The client requirement is

the Logic should pick PGI quantity not shipped.

Also the first day is Sunday not Monday. It should always start on

Sunday and collate the details till Saturday, then start again on

Sunday.

please can any one help how write logic for the above.

Thanks,

Naresh