Hi Krystal

I can't see the previous posts in this thread, so I am unclear as to how
your data is set out.
But, assuming as per Herbert's example you date a date field and a Value
field, drag date to the Row Area and Value to the Data area.
Right click on any dateGroup and OutlineGroupDays7
Now drag Value to the Data area a second timeDouble click the field
nameShow data as% Difference fromDatePrevious

If you are still having difficulty and want to send me a copy of your
workbook, I will set it up for you
To mail direct
roger at technology4u dot co dot uk
Do the obvious with at and dot
--
Regards
Roger Govier

"Krystal Peters" wrote in message
...
How about for Excel 2003? Need to do the same thing but the Excel 2003

"Herbert Seidenberg" wrote:

Excel 2007 PivotTable
Group by week.
Two ways.
http://www.mediafire.com/file/wbzxgwnzmzx/08_12_09.xlsx


__________ Information from ESET Smart Security, version of virus
signature database 4530 (20091021) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4530 (20091021) __________

The message was checked by ESET Smart Security.

http://www.eset.com