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:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Customer[/TD]
[TD]Date[/TD]
[TD]$[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]Jan-18[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]Jan-18[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]Feb-18[/TD]
[TD]75[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]Feb-18[/TD]
[TD]75[/TD]
[/TR]
[TR]
[TD]XYZ[/TD]
[TD]Jan-18[/TD]
[TD]125[/TD]
[/TR]
[TR]
[TD]XYZ[/TD]
[TD]Jan-18[/TD]
[TD]125[/TD]
[/TR]
[TR]
[TD]XYZ[/TD]
[TD]Feb-18[/TD]
[TD]150[/TD]
[/TR]
[TR]
[TD]XYZ[/TD]
[TD]Feb-18[/TD]
[TD]150[/TD]
[/TR]
</tbody>[/TABLE]

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

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Jan-18[/TD]
[TD]Feb-18[/TD]
[TD]Difference[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]100[/TD]
[TD]150[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]XYZ[/TD]
[TD]250[/TD]
[TD]300[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD]350[/TD]
[TD]450[/TD]
[TD]100[/TD]
[/TR]
</tbody>[/TABLE]

Any help would be be appreciated.

Thank you,

 

[john-paul]

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