Este es el codigo que le puesto.
Código SQL:
Ver originalSELECT o.ShipCountry Pais,
CASE WHEN datepart(yyyy,o.OrderDate)=1996 THEN SUM(od.UnitPrice*od.Quantity) END AS [1996],
CASE WHEN datepart(yyyy,o.OrderDate)=1997 THEN SUM(od.UnitPrice*od.Quantity) END AS [1997],
CASE WHEN datepart(yyyy,o.OrderDate)=1998 THEN SUM(od.UnitPrice*od.Quantity) END AS [1998]
FROM [ORDER Details] od
INNER JOIN Orders o ON o.OrderID=od.OrderID
GROUP BY o.ShipCountry,YEAR(o.OrderDate)
Pareciera que me mostrara solo un monto de los tres años.