Pivot Tables - Difference From
 

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

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