Declare
@Dep1  Char(03),
@Dep2  Char(03),
@Dep3  Char(03)

set @Dep1  = '001' 
set @Dep2  = '002' 
set @Dep3  = '003' 

SELECT 
  [Produto  / Deposito]=CASE WHEN row IS NULL THEN 'Sum' 
                   ELSE CONVERT(VARCHAR(80),[row]) END ,
  [001]   = SUM( CASE col WHEN @dep1   THEN data ELSE 0 END ),
  [002]   = SUM( CASE col WHEN @dep2   THEN data ELSE 0 END ),
  [003]   = SUM( CASE col WHEN @dep3   THEN data ELSE 0 END ),
  [Total] = SUM( data )
FROM 
   (SELECT [row]  = pro_codigo  , 
           [col]  = dep_codigo , 
           [data] = sum(pro_saldo_fis1)
    FROM Produto  INNER JOIN deposito  
    ON (produto.pro_deposito =deposito.dep_codigo) 
    GROUP BY pro_codigo , dep_codigo  
    ) f
GROUP BY row WITH ROLLUP
ORDER BY GROUPING(row),total DESC