I have the following query

```
SELECT
    MONTH(PaymentDate) AS [month], 
    YEAR(PaymentDate) AS [year], 
    SUM(OutstandingPayment) AS totalCollected
FROM 
    Payments
WHERE 
    PaymentDate BETWEEN '01/01/2016' AND '12/31/2017' 
GROUP BY
    YEAR(PaymentDate), MONTH(PaymentDate)
ORDER BY 
    YEAR(PaymentDate), MONTH(PaymentDate)

```

The output is below

```
month       year    totalCollected
----------------------------------
1           2016    10000
2           2016    11000
3           2016    12000
4           2016    13000
5           2016    14000
6           2016    15000
7           2016    16000
8           2016    17000
9           2016    18000
10          2016    19000
11          2016    20000
12          2016    21000
1           2017    11000
2           2017    12000
3           2017    13000
4           2017    14000
5           2017    15000
6           2017    16000
7           2017    17000
8           2017    18000
9           2017    19000
10          2017    20000
11          2017    21000
12          2017    22000

```

I would like the output to be 

```
Month   2016    2017    $Change %Change
----------------------------------------
   1    10000   11000   1000    10.00%
   2    11000   12000   1000    9.09%
   3    12000   13000   1000    8.33%
   4    13000   14000   1000    7.69%
   5    14000   15000   1000    7.14%
   6    15000   16000   1000    6.67%
   7    16000   17000   1000    6.25%
   8    17000   18000   1000    5.88%
   9    18000   19000   1000    5.56%
   10   19000   20000   1000    5.26%
   11   20000   21000   1000    5.00%
   12   21000   22000   1000    4.76%

```

The `$change` is 2017 data - 2016 data. The percent change is ((2016 Data - 2017 Data)/2017 Data).

How do I pivot the data and add the calculated columns? 

Thanks in advance.