Subtracting from same column and show difference and percentage change in new columns

[limats]

Hi everyone,

Please may I ask hopefully a simple question; I have the below input data which I am trying to find the change per quarter by subtracting a row below from the row above for each row, and also the percentage change in two new columns. I would like to have the data presented in exactly the below format. 

Any help would be much appreciated - many thanks in advance!

Input

Date	Amount
4Q14	1000
1Q15	800
2Q15	600
3Q15	500
4Q15	700
1Q16	1000
2Q16	1200
3Q16	900
4Q16	800

Desired Output

Date	Amount	Delta	% Delta
4Q14	1000	n/a	n/a
1Q15	800	-200	-20
2Q15	600	-200	-25
3Q15	500	-100	-17
4Q15	700	200	40
1Q16	1000	300	43
2Q16	1200	200	20
3Q16	900	-300	-25
4Q16	800	-100	-11

[RishiK]

@limats have a look at the attached sample workflow I built for you.

The Multi Row Formula tool really helps here when you are referring to the "row above" or "Row-1" and applying a calculation on your "Active Row".

Have a look and let me know what you think.

[Qiu]

@limats 
Just trying a different approach.