# Need Formula To Decrease Subtract in Pivot Table

##### Well-known Member
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

Last edited:

### Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

#### mole999

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

##### Well-known Member
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..

##### Well-known Member
bump!

Replies
3
Views
343
Replies
1
Views
180
Replies
1
Views
402
Replies
3
Views
472
Replies
20
Views
471

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,414
Messages
5,831,468
Members
430,070
Latest member
Kevinlim2007

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back