How to create an accumulate total field in Pivot Table?

Mar 7th, 2002, 10:11 PM

Region (All)

Sum of SalesAmount
Time Total Accumulate Total
2001-Dec 650 650
2001-Nov 450 1100
2001-Oct 250 1350
2002-Feb 1050 2400
2002-Jan 850 3250
Grand Total 3250

Mar 8th, 2002, 08:01 AM

Place a 2nd copy of 'SalesAmount' field button in your PivotTable's DATA area. While still in the PivotTable wizard, double-click the 'Sum of SalesAmount2' field button and press [ Options>> ]. Set the "Show data as" drop down list to "Running Total In" with a "Base field" of "Time" and press [ OK ]. Double-click the 'Sum of SalesAmount2' field button once more and change it's "Name" to "Accumulate Total".

Press the wizard's [ Finish ] button.

sasinid · Mar 10th, 2002, 08:30 PM

I've tried and it's worked. Thank you very much.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 7th, 2002, 10:11 PM	#1
Guest Posts: n/a	Region (All) Sum of SalesAmount Time Total Accumulate Total 2001-Dec 650 650 2001-Nov 450 1100 2001-Oct 250 1350 2002-Feb 1050 2400 2002-Jan 850 3250 Grand Total 3250

Mar 8th, 2002, 08:01 AM	#2
Guest Posts: n/a	Place a 2nd copy of 'SalesAmount' field button in your PivotTable's DATA area. While still in the PivotTable wizard, double-click the 'Sum of SalesAmount2' field button and press [ Options>> ]. Set the "Show data as" drop down list to "Running Total In" with a "Base field" of "Time" and press [ OK ]. Double-click the 'Sum of SalesAmount2' field button once more and change it's "Name" to "Accumulate Total". Press the wizard's [ Finish ] button.

Mar 10th, 2002, 08:30 PM	#3
sasinid New Member Join Date: Mar 2002 Posts: 1	I've tried and it's worked. Thank you very much.