Ok, so what part do you need the help with. As from what you say you have the SQL which will return the individual company and also the All Company the same data should display on the report you currently have?

Sorry for all the questions, want to make sure on the same page 😉