SAP Business One query to compare sales turnover between two salespersons

 SELECT 

    T0.SlpName AS 'Sales Person', 

    YEAR(T1.DocDate) AS 'Year',

    MONTH(T1.DocDate) AS 'Month',

    SUM(CASE WHEN T1.SlpCode = 'SLP001' THEN T1.LineTotal ELSE 0 END) AS 'Sales Turnover 1',

    SUM(CASE WHEN T1.SlpCode = 'SLP002' THEN T1.LineTotal ELSE 0 END) AS 'Sales Turnover 2'

FROM 

    OSLP T0 

    INNER JOIN OINV T1 ON T0.SlpCode = T1.SlpCode 

WHERE 

    T1.DocStatus = 'C' 

    AND YEAR(T1.DocDate) = YEAR(GETDATE()) 

    AND T0.SlpCode IN ('SLP001', 'SLP002')

GROUP BY 

    T0.SlpName, 

    YEAR(T1.DocDate), 

    MONTH(T1.DocDate)