Prev: columns
Next: Opening Excel 2007 in Excel 2000
From: I Teach on 23 Apr 2010 16:28
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
From: Jim Thomlinson on 23 Apr 2010 16:32
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
 | 
Pages: 1
Prev: columns
Next: Opening Excel 2007 in Excel 2000