Sorting within Groupings
 

I was wondering if it's possible to sort within groupings in excel. For
Example I have a lost of companies in a worksheet in grouped by Sector (i.e.
energy, IT, consumer discretionary) then sub grouped by industry (i.e. oil,
gas), and when i try to sort by a column for return (10%, 20%) the groups
level returns get sorted but not the security level returns within those
industries. Is this possible?