akim
New Member
- Joined
- Jul 14, 2022
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
Hi all !
I am currently working on a Pivot table to manage my inventory. See below a sample of the pivot table
For each IMP, I want to automatically reflect the balance between the value in "IN" and the sum of values in "OUT".
For example for D77 I want to reflect : 4000 - (400 + 300 + 175 + 1000 + 400 + 500 + 50 + 225 + 150 + 475 + 325) = 0
I have tried to set up a calculated field using (IN) - (OUT) but it reflects the results on every row which is not what I am looking for.
PS : I highlighted where I would like it to be reflected, and wrote manually the values to give you a better idea of what I want to get.
Thank you in advance for anyone that will be able to help me out on this !!
Akim
I am currently working on a Pivot table to manage my inventory. See below a sample of the pivot table
For each IMP, I want to automatically reflect the balance between the value in "IN" and the sum of values in "OUT".
For example for D77 I want to reflect : 4000 - (400 + 300 + 175 + 1000 + 400 + 500 + 50 + 225 + 150 + 475 + 325) = 0
I have tried to set up a calculated field using (IN) - (OUT) but it reflects the results on every row which is not what I am looking for.
PS : I highlighted where I would like it to be reflected, and wrote manually the values to give you a better idea of what I want to get.
Thank you in advance for anyone that will be able to help me out on this !!
Akim