| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Why does -1, -1, and 2 equal 4 in a pivot table
Trying to do a pivot table to calculate processing time using Beginning
Inventory + Received - Ending Inventory. Used formulas to 'Reverse' Ending inventory thinking I could do a Pivot table on the results however the Pivots appear to be using the absolute values. Confirmed this using Drill down to review the data and the values are no longer showing the negative signs. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
| pivot table | Excel Worksheet Functions | |||
| Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
| Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions | |||
Linear Mode
