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.