又没有大佬能帮我解决一下呀

[J979369235]

SUM(if((date_format(DATE_ADD(TradeTime,interval 0 MONTH),'%Y-%m')!=left(b.BillPeriod,7) or BusinessBillNo='') AND TravelType=1,OrderMoney,0)) AS 未进T金额,
SUM(if((date_format(DATE_ADD(TradeTime,interval 1 MONTH),'%Y-%m')!=left(b.BillPeriod,7) or BusinessBillNo='') AND TravelType=1,OrderMoney,0)) AS 未进T加1金额,
SUM(if((date_format(DATE_ADD(TradeTime,interval 2 MONTH),'%Y-%m')!=left(b.BillPeriod,7) or BusinessBillNo='') AND TravelType=1,OrderMoney,0)) AS 未进T加2金额,
SUM(if((date_format(DATE_ADD(TradeTime,interval 3 MONTH),'%Y-%m')!=left(b.BillPeriod,7) or BusinessBillNo='') AND TravelType=1,OrderMoney,0)) AS 未进大于T加2金额,

当条件满足其中一个的时候，只展示满足条件那一列的数据，这个需要怎么解决呀

[Kings_cool]

case when

[fatxinglee]

case when xxx then yyy when 111 then 222 end