Sean15
Well-known Member
- Joined
- Jun 25, 2005
- Messages
- 719
- Office Version
- 2010
- Platform
- Windows
Hello:
Is it possible to prevent Excel pivot table from netting values in Sum of Total? I have several negative and positive values that sum up to zero and Excel is displaying a zero value but I want the pivot table to show all values (negative and positive). I checked the value field setting but I can't find a suitable setting. Any suggestions?
Thank you.
Sean
Is it possible to prevent Excel pivot table from netting values in Sum of Total? I have several negative and positive values that sum up to zero and Excel is displaying a zero value but I want the pivot table to show all values (negative and positive). I checked the value field setting but I can't find a suitable setting. Any suggestions?
Thank you.
Sean
Last edited: