hi all and thanks if you respond

a quick question if you have a range full of values how do you create a
total function that breaks the amounts by a break point similar to the pivot
table function - for those who know Oracles OLAP DML or Express Server or
Personel Express my example is

limit product code to all
limit brand to all
report width 30 total(sales brand )

where product code has been related to brand

so can we force excel to do this easily


--
C Ward