Hi,

I understand that is not simple, since you must be working in different time zone, I ma in EST in USA, so I could not reply in between, while you guys are trying to figure it out.

My question is ,

what is the output you want to look like?

Can you put that in a tabular format in excel and attach here, so that makes easier to figure out what you need. I could only see in your first post how you wanted the out put but what was this

Records must be in this specific order:

OnlineDotCom (Company totals)

Memphis (District totals)

0001 (storeNbr totals)

0002 (storeNbr totals)

Tupelo (districtName totals)

0003 (storeNbr totals)

0004 (storeNbr totals)

Almost all the replies in between were how you want,what are the columns in order by, etc etc..

What columns constitutes Totals? Which columns should be summed up to get that total figure? A better way of displaying would be in a tabular format in excel, that would be helpful even any one trying to figure out what you want achieve.