Demo, Sql Server - rextester

Language: Layout:

CREATE TABLE ORDERS
    ([CustName] varchar(5), [OrderedProduct] varchar(13), [QtyOrdered] int, [UnitCost] int, [UnitPrice] int, [OrderDate] datetime)
;
    
INSERT INTO ORDERS
    ([CustName], [OrderedProduct], [QtyOrdered], [UnitCost], [UnitPrice], [OrderDate])
VALUES
    ('Bob', 'Canned Tuna', 6, 11, 14,     '12-21-2016 13:11:00'),
    ('Steve', 'Canned Salmon', 2, 15, 19, '11-03-2016 11:03:00'),
    ('Bob', 'Canned Tuna', 10, 10, 13,    '12-22-2016 10:43:00'),
    ('Bob', 'Canned Tuna', 4, 9, 10,      '11-13-2016 17:22:00')
;
SELECT CustName, OrderedProduct, [VOL Dec 2016], [VOL Nov 2016], [MAR Dec 2016], [MAR Nov 2016] FROM
(
    SELECT CustName, OrderedProduct,YearMonth,val
    FROM [ORDERS]
    cross apply (values ('VOL ' + CONVERT(CHAR(4), OrderDate, 100) + CONVERT(CHAR(4), OrderDate, 120),QtyOrdered),('MAR ' + CONVERT(CHAR(4), OrderDate, 100) + CONVERT(CHAR(4), OrderDate, 120),((UnitPrice-UnitCost)*QtyOrdered))) tc
    (YearMonth,val)
    WHERE CustName='Bob'
) src
PIVOT
(
    SUM(val)
    FOR YearMonth IN ([VOL Dec 2016], [VOL Nov 2016],[MAR Dec 2016], [MAR Nov 2016])
) pvtvol

;with QtyOrdered as
(
SELECT CustName, OrderedProduct, [VOL Dec 2016], [VOL Nov 2016]FROM
(
    SELECT CustName, OrderedProduct, QtyOrdered,
    'VOL ' + CONVERT(CHAR(4), OrderDate, 100) + CONVERT(CHAR(4), OrderDate, 120) AS YearMonthVol
    FROM [ORDERS]
    WHERE CustName='Bob'
) src
PIVOT
(
    SUM(QtyOrdered)
    FOR YearMonthVol IN ([VOL Dec 2016], [VOL Nov 2016])
) pvtvol
),Margin as 
(
    select * from (
SELECT CustName, OrderedProduct, ((UnitPrice-UnitCost)*QtyOrdered) AS Margin,
    'MAR ' + CONVERT(CHAR(4), OrderDate, 100) + CONVERT(CHAR(4), OrderDate, 120) AS YearMonthMar
    FROM [ORDERS]
    ) a
PIVOT
(
    SUM(Margin)
    FOR YearMonthMar IN ([MAR Dec 2016], [MAR Nov 2016])
) pvtmar
WHERE CustName='Bob'    
)
select q.CustName,q.OrderedProduct,[VOL Dec 2016], [VOL Nov 2016],[MAR Dec 2016], [MAR Nov 2016]
from QtyOrdered q
join Margin m on q.CustName = m.CustName 
and q.OrderedProduct = m.OrderedProduct

View schema
Execution time: 0,03 sec, rows selected: 2, rows affected: 4, absolute service time: 0,2 sec