If I understand your question correctly, you want just to put the results together in a single query. For that you can use
UNION ALL
. Something like
Select 'Locations', LocCode, (Qty/Capacity)*100
from myTable
group by 'Locations', LocCode
UNION ALL
Select 'Regions', Region, (Qty/Capacity)*100
from myTable
group by 'Regions', Region