行转列，这次我是折线图用到的

SELECT DISTINCT
 ProdDate1,
  DeptName,
  SUM(case ProductDes WHEN '砂' THEN CollectAmount  ELSE 0 END) as '砂',
  SUM(case ProductDes WHEN '铁精粉' THEN CollectAmount ELSE 0 END) as '铁精粉'
  FROM
    (SELECT distinct
 top 100 percent
 SUM( UMEsale.CollectAmount) as CollectAmount,
 
 CONVERT(varchar(100), ProdDate, 23) AS ProdDate1,
 
 sys_dept.dept_name AS DeptName,
 
   sys_dict_data.dict_label AS ProductDes
    FROM  
 UMEsale
 LEFT JOIN sys_dept ON UMEsale.UnitID = sys_dept.dept_id
 LEFT JOIN sys_jl_productrel ON UMEsale.MaterialID = sys_jl_productrel.materialid
 LEFT JOIN sys_dict_data ON sys_dict_data.dict_code = sys_jl_productrel.product_id

GROUP BY sys_dept.dept_name,sys_dict_data.dict_label,ProdDate

) AS C

GROUP BY 
ProdDate1,DeptName
ORDER BY ProdDate1 desc