Negative Numbers in a Pivot Table
I have an excel spread sheet with negative and positive numbers and when I
do calculations in excel, the negative numbers are subtracted from the positive numbers for a total. However, when I try to use a pivot table, 2 negative numbers are added together and reported as a positive number. How can I get the negative numbers to subtract in a pivot? |
Negative Numbers in a Pivot Table
I've never seen this.
Are you sure that you don't have more rows that go into that sum than you think? PB wrote: I have an excel spread sheet with negative and positive numbers and when I do calculations in excel, the negative numbers are subtracted from the positive numbers for a total. However, when I try to use a pivot table, 2 negative numbers are added together and reported as a positive number. How can I get the negative numbers to subtract in a pivot? -- Dave Peterson |
All times are GMT +1. The time now is 10:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com