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.