怎么将RPT_DATE转为行，TOTAL转为列 。为什么这个转不了！截图是子查询的结果

select 

MAX(CASE RPT_DATE WHEN '2023/9/6' THEN TOTAL ELSE 0 END) AS RPT_DATE

 from (

SELECT RPT_DATE, SUM(FEED8_CSP_QTY + FEED8_CSP_AMT + FEED12_CSP_QTY + FEED12_CSP_AMT + FEED8_PILLAR_QTY + FEED8_PILLAR_AMT + FEED12_PILLAR_QTY + FEED12_PILLAR_AMT) AS TOTAL

FROM RPT_PC_OUTPUT_A

GROUP BY RPT_DATE)