Need Formula To Decrease Subtract in Pivot Table

muhammad susanto

Well-known Member
Joined
Jan 8, 2013
Messages
1,959
Office Version
  1. 2013
Platform
  1. Windows
hi all...

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




namedateamount
zidan2/1/201710
naufal3/1/20177
kucing3/1/201712
brol3/1/201712
robes3/1/201710
garcil3/1/20179
zidan2/2/20173
zidan3/2/20172
naufal5/5/20171
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
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
what determines that the first value is not already a subtraction, ideally you woul have an IN and OUT values
 

muhammad susanto

Well-known Member
Joined
Jan 8, 2013
Messages
1,959
Office Version
  1. 2013
Platform
  1. Windows
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..
 
Master Excel Bundle

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.

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top