Hi,
I have a database which contains the data of receipt of material. Every day
I used to download the data in a workbook. from that workbook I have created
pivot table which contains the field like Item No. in row field, date in
column field & the data field is the sum of Qty something like this :
DESIRED DATE
im_code 01/04/2006 02/04/2006 03/04/2006
ATM0083 10 20 5
ATM0641 2 6 20
TUD004A 45 75 40
TUD005A 66 47 36
Now i want to add a calculated field which adds the sum of Qty. for previous
date i.e the cumulative figure of the received material for every day. The
output / result would be something like :
DESIRED DATE
im_code 01/04/06 Cum.01/04/06 02/04/06 Cum.02/04/06 03/04/06 Cum. 03/04/06
ATM0083 10 10 20 30 5 35
ATM0641 2 2 6 8 20 28
TUD004A 45 45 75 120 40 160
TUD005A 66 66 47 113 36 149
Could anybody help me out to solve this problem or is their any other way to
get the cumulative figure of receipt material for each day.
Thanks in advance.
--
Vikram Dhemare