| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I inserted a field =Amount1 - amount2 -PivotTable-doesn't work
I inserted a field =amount1 - amount2 into a pivottable but it doesn't work.
shows diferente result. for instance amount1=10,000 and amount2=3,000 - the field should show amount1 - amount2... 10,000-3,000 = 7,000 but shows a big number that doesn't make sense. what i am doing wrong? mark |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can array formulas work if rows are inserted? | Excel Worksheet Functions | |||
| Calculated fields in pivot tables | Excel Worksheet Functions | |||
| master select page field for many pivots in one work book | Excel Discussion (Misc queries) | |||
| How do I refresh a PivotTable and remove outdated page field entr. | Excel Discussion (Misc queries) | |||
| PivotTable Column Field Values | Excel Discussion (Misc queries) | |||
Threaded Mode
