A spreadsheet is attached of the data with companyname and districtname column.

It does appear there is duplicate data for some stores on some dates. Assume this is by design. The relevant part is the summations and the rolloup. I will however repost data when I get a chance.