View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Pivot Tables - Difference From

Drag a second instance of the field you are aggregating into the data area.
--
HTH...

Jim Thomlinson


"I Teach" wrote:

When I display years and I would like to know the Difference From previous in
either Excel 2003 or 2007, the values in the previous year do not display,
only the resulting difference. Is it possible to display the previous year's
values so the difference would make sense?

Thanks for your assistance.
--
I Teach