I have a monthly report showing forecast planned orders
that is pulled weekly.I need to compare the week to week data and report the
differences in item and qty.
I need to show what items that may have disappeared
and how much and what data has appeared and how much and the difference
between items that are still there.
Any ideas?
TIA

In the pivot table, you can use the Difference From custom calculation
to compare each week to the previous one. There are examples he

http://www.contextures.com/xlPivot10.html

E wrote:
I have a monthly report showing forecast planned orders
that is pulled weekly.I need to compare the week to week data and report the
differences in item and qty.
I need to show what items that may have disappeared
and how much and what data has appeared and how much and the difference
between items that are still there.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

I should have stated that each week has its own worksheet and pivot
table.And each month has its own spreadsheet.I need to compare week to week
across worksheets and spreadsheets.

"Debra Dalgleish" wrote in message
...
In the pivot table, you can use the Difference From custom calculation
to compare each week to the previous one. There are examples he

http://www.contextures.com/xlPivot10.html

E wrote:
I have a monthly report showing forecast planned orders
that is pulled weekly.I need to compare the week to week data and report
the
differences in item and qty.
I need to show what items that may have disappeared
and how much and what data has appeared and how much and the difference
between items that are still there.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html