Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pb pb is offline
external usenet poster
 
Posts: 19
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Displaying Text, not numbers, in Pivot Table Longtime listener first time caller New Users to Excel 2 March 8th 07 10:44 AM
Making Text into Numbers, for Pivot Table Cubes traceye Excel Worksheet Functions 0 January 31st 07 12:04 PM
Set negative numbers to zero. Do not calculate with negative valu Excel Headache Excel Discussion (Misc queries) 4 September 14th 06 08:56 PM
Pivot Table keep apart cells text that I've formatted as numbers Paulo Bevervanso Excel Worksheet Functions 2 September 21st 05 08:45 PM
I am having trouble keeping numbers formatted in a Pivot Table Liana H Excel Discussion (Misc queries) 1 April 22nd 05 07:43 PM


All times are GMT +1. The time now is 10:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"