| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying Text, not numbers, in Pivot Table | New Users to Excel | |||
| Making Text into Numbers, for Pivot Table Cubes | Excel Worksheet Functions | |||
| Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) | |||
| Pivot Table keep apart cells text that I've formatted as numbers | Excel Worksheet Functions | |||
| I am having trouble keeping numbers formatted in a Pivot Table | Excel Discussion (Misc queries) | |||
Threaded Mode
