Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have added the same field twice to a pivot table. On Field Properties for
the second copy of the field I set it to display as Difference From and picked the Base Field and Previous... but it only displays #N/A. Other display as settings work fine (e.g. % of row) but not this one. I am using Excel 2003 on Win XP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating the difference between cells | Excel Worksheet Functions | |||
add a column to a pivot table that would show the difference between 2 other Columns | Excel Worksheet Functions | |||
Sum Function sometimes displays incorrect answer | Excel Worksheet Functions | |||
calculate negative or positve difference in time | Excel Discussion (Misc queries) | |||
Formula window displays correct answer while cell displays incorre | Excel Worksheet Functions |