muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all...
i need your help in pivot table formula to calculate subtract decrease data
like this below :
<tbody>
</tbody>
if in group date 3/2/2017 eg. for zidan = 10-3-2=5 (decrease subtract)
any help, much appreciated..
m.susanto
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: