Pivot in SQL Server 2014

Question

Hello, I need to do a pivot in sql server 2014 but failed. I read several forums but none of them helped. Below is my Table that I would like to pivot:

 

 

 Below is my desired result:

 

 

 This is what I have so far but have an error:

DECLARE   @Query AS NVARCHAR(MAX)
DECLARE   @PivotProductType AS NVARCHAR(MAX)

--Get unique values of pivot column
SELECT   @PivotProductType= COALESCE(@PivotProductType + ',','') + QUOTENAME(ProductType)
FROM (SELECT DISTINCT ProductType FROM tblAgentCommission) AS PivotColumn

SELECT   @PivotProductType

--Create the dynamic query with all the values for
--pivot column at runtime
SET   @Query =
    N'SELECT Country, ' +   @PivotProductType + '
    FROM [dbo].[PivotColumn]
    PIVOT(CommissionRate)
          FOR ProductType IN (' + @PivotProductType + ')) AS P'

SELECT   @Query
--Execute dynamic query
EXEC sp_executesql @Query

 

Thanks in Advance.