quantity sold on oldest date using minimum date

I have a report that needs to find the beginning stock on the oldest available date for each store. Using efashion, picture it this way, I need the quantity sold in the past for the earliest available year. I need this quatity to be returned in the footer of each section for each store. Thank you for any help.