I solved the question with the help of below link :

http://stackoverflow.com/questions/14694691/sql-server-pivot-table-with-multiple-column-aggregates

declare @Sql nvarchar(max)

select @Sql='SELECT min(t.code) As CODE,PRODNAME'

DECLARE @ColumnTemplate NVARCHAR(MAX)

select @ColumnTemplate='SUM(CASE WHEN t.department=''{department}'' THEN t.netqty ELSE 0 END) AS "{department}_NetQty"

,SUM(CASE WHEN t.department=''{department}'' THEN t.netmrp ELSE 0 END) AS "{department}_NetMrp"'

SELECT @Sql=@Sql+CHAR(13)+','+REPLACE(@ColumnTemplate, '{department}', REPLACE(c.name,'''',''''''))

FROM (

SELECT DISTINCT t.department AS name

FROM consumption t

) c

SELECT @Sql=@Sql+'FROM consumption t GROUP BY t.prodname order by code;'

--PRINT @Sql;

EXEC(@Sql);

Regards

Girish Sharma