A pivot table can display a running total, as described he

http://www.contextures.com/xlPivot10.html#Running

You may need to rearrange the data fields so they appear horizontally:

http://www.contextures.com/xlPivot02.html


wrote:
I am using pivot report. I am having monthwise qty in pivot report. ex.

Month Qty.
Jan 10
Feb 15
Mar 18
Total 43

I want in following in same report
Month Qty. Commu. Qty.
Jan 10 10
Feb 15 25
Mar 18 43
Total 43

can anybody help me in this regard. mail me at


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