ask again: about privot table

[Martin \(Martin Lee\)]

(Is it really so difficult??? Or, is it impossible???)

DATA:

2006-1-1 to 2006-1-31 3 units
2006-2-1 to 2006-2-28 4 units
2006-3-1 to 2006-3-31 2 units

I want, in the Privot Table to accumulate calculating as below result:

2006-1-1 to 2006-1-31 3 units
2006-2-1 to 2006-2-28 7 units (accumulate 3+4)
2006-3-1 to 2006-3-31 9 units (accumulate 3+4+2)

How to achieve this in the Private Table ?

Thanks!


Martin Lee

 

[Douglas J. Steele]

In a table? You can't do it (nor should you)

In a report? Set the Running Sum property of the text box.