RE: Some OLAP function perhaps?

This works:

create table rob.libsum as (
with totrows as
(select diobli as library, sum(diobsz) as libsize,
Dense_Rank() Over(Order By sum(diobsz) Desc) as libRank
from qusrsys.qaezdisk
where diobli<>''
group by diobli),
topten as (Select diobli as objLibrary, diobnm as Object, diobsz as Size,
Dense_Rank() Over(Partition By diobli Order By diobsz
Desc) as objRank

From qusrsys.qaezdisk

where diobli<>''),
combine as
(select library, libsize, librank, object, size, ObjRank
from Totrows join topten on library=objlibrary)
select library, '' as object, libsize as size, librank,0 as objrank
from totrows
union all
select '' as library,object,size, librank,objrank
from combine
where objrank<=25
order by librank, objrank)
with data;

Thanks to all.

Rob Berendt