Add another copy of the Amount field to the pivot table data area
Right-click on the heading for the new field
Choose Field Settings
Click the Options button
From 'Show Data As', select Running Total
For the Base Field, choose Day
Click OK

Kurt wrote:
Hi all.

Does anybody of you know, how I can show in a Pivot table
accumulated values (example)in each row:

Day Amount Accum. Value
1 50 50
3 75 125
8 105 230
.. .. ..
.. .. ..

and so on.

Maybe someone give me a tip.

Thanx a lot

Regards Kurt


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html