ExcelBanter - Difference From displays #N/A

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Difference From displays #N/A (https://www.excelbanter.com/excel-discussion-misc-queries/15556-difference-displays-n.html)

STEVE

Difference From displays #N/A

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

All times are GMT +1. The time now is 08:38 PM.