Pivot table difference column (same field)

[john-paul]

Hi,

I am trying to create an additional column (field/item/calculated?) in a pivot table to show the difference row by row.

My data is like this:

Customer	Date	$
ABC	Jan-18	50
ABC	Jan-18	50
ABC	Feb-18	75
ABC	Feb-18	75
XYZ	Jan-18	125
XYZ	Jan-18	125
XYZ	Feb-18	150
XYZ	Feb-18	150

<tbody>
</tbody>

I would like to produce a report like this, where the Difference column if Feb-18 - Jan-18 to show growth month on month:

	Jan-18	Feb-18	Difference
ABC	100	150	50
XYZ	250	300	50
Total	350	450	100

<tbody>
</tbody>

Any help would be be appreciated.

Thank you,

 

[john-paul]

Edit: I though I had it but not sure now.