Group-by In Subselect With Union

[RSN]

I hav a query that uses a union of 16 tables to get some counts and i need to get the end result as a Group by. This is inside a sub-query that has the count(*) ans the attribute for the group-by in the select. i need to get the end result as the count for each of the group displayed as a title based on a criteria on the group attribute.
the query is something like this.. but i am not able to get the top most part ie getting to display the title based on the group-by attribute.

select cnt,
         case
         when attr = 'aaa' then cnt as Title1
         when attr = 'bbb' then cnt as Title2
         else cnt as Title3
         end
from 
(select sum(cnt) , attr
 from
(select count(acct) as cnt, attr
 from table1
 wher..
 union all
 select count(acct), attr
 from table2
 where..
union all
...
select count(acct), attr
 from table16
 where..
) as ctr
group by attr ) as grp

[Please use CODE tags when posting source code. Thanks! --pbmods]