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