Hi

If your source data is already cumulative, then the Pt cannot do what you
require.
You would need to create daily figures from your source table.

Assuming your data looks like this
Date Amount Code
1/1/7 100 XXX
2/1/7 200 XXX
3/1/7 300 XXX

and so on with all the data for each of the codes YYY and ZZZ.
First Sort your data by Code and Date
in Cell D2 enter the following
=IF(C2<C1,B2,IF(B2=D1,0,B2-B1))
Copy down as far required
Put a Heading of Amount2 in cell D1
Extend the range for the source data for your Pivot table to include column
D

Remove Amount from the Data area and insert Amount2 instead.
Refresh the table and you will have the layout you want.

--
Regards
Roger Govier

"Dolphinv4" wrote in message
...
Hi,

tried what you said but it isn't what i wanted. The result is that it is
accumulative. Let me detail my prob:
XXXX YYYY ZZZZ
1/1/07 100
2/1/07 200 300 400
3/1/07 300 300 400
4/1/07 300 300 400
5/1/07 700 400 450

Correct?

Thanks.

Dolphin

assuming 3rd & 4th are saturday & sunday respectively, I'd like the pivot
table to show:

XXXX YYYY ZZZZ
1/1/07 100
2/1/07 200 300 400
3/1/07 300
4/1/07
5/1/07 400 100 50

The above is what I wanted.

However, according to what you said, if I had done it correctly, it
appears
this way:

XXXX YYYY ZZZZ
1/1/07 100
2/1/07 200 300 400
3/1/07 200 300 400
4/1/07 200 300 400
5/1/07 400 100 50



"Roger Govier" wrote:

Hi
Double click your Value fieldOptionsShow data asRunning Total inDate
If you want to show the actual daily values as well, drag the Value field
to
the Data area twice, once set as above and once as Normal.
If you want the columns side by side drag the Data button and drop on
Total.

--
Regards
Roger Govier

"Dolphinv4" wrote in message
...
Hi,

I have a pivot table with the dates rows field and a/c no. on the
column
fields. however, there are some dates whereby there is no amount
because
these are weekends. What I want is for those blanks, I want it to
follow
the
same amount as the last balance, ie, for saturday & sunday, the balance
should show the balance as at firday instead of NIL.

What is the easiest way to do it?

Thanks.