Running Total

[nc]

Sum of Cost/Proceeds Transaction Type
Month Purchases
August 66,459.70
September 495,489.33
October 313,070.28
November 19,180.30
December 58,162.84
January 153,562.11
February 132,805.22
March 161,577.92
Grand Total 539,967.36

How do I include a running total for the Purchases
Field/Item in this pivottable?

 

[Norman Harker]

Hi nc!

Assuming your August figure is in B2

C2:
=SUM($B$2:B2)
Copy down

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Andy B]

Hi

If I understand you correctly, try this. In the next column type:
=SUM($A$2:A2)
and fill down.

Andy.

 

[Debra Dalgleish]

Add the Cost field to the data area again.
Right-click on the column heading for the new field.
Select Field Settings, and click Options
From 'Show Data as', select 'Running Total in'
From the Base Field list, select Month
Click OK

 

[nc]

Thanks Debra.

-----Original Message-----
Add the Cost field to the data area again.
Right-click on the column heading for the new field.
Select Field Settings, and click Options
From 'Show Data as', select 'Running Total in'
From the Base Field list, select Month
Click OK



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

.