Need Formula To Decrease Subtract in Pivot Table

[muhammad susanto]

hi all...

i need your help in pivot table formula to calculate subtract decrease data
like this below :

name	date	amount
zidan	2/1/2017	10
naufal	3/1/2017	7
kucing	3/1/2017	12
brol	3/1/2017	12
robes	3/1/2017	10
garcil	3/1/2017	9
zidan	2/2/2017	3
zidan	3/2/2017	2
naufal	5/5/2017	1
etc..

<tbody>
</tbody>

if in group date 3/2/2017 eg. for zidan = 10-3-2=5 (decrease subtract)

any help, much appreciated..

m.susanto

 

[mole999]

what determines that the first value is not already a subtraction, ideally you woul have an IN and OUT values

 

[muhammad susanto]

what determines that the first value is not already a subtraction, ideally you would have an IN and OUT values

hi mole..

in the same name, the first value is the first date as IN values and the next value as subtraction (OUT) values..

 

[muhammad susanto]

bump!