Accumulate data in pivottable

[Guest]

Hello

Is there a way that I can get accumulated values in a pivottable. Now I can see if we make e.g. 15 pieces week 2, 15 pieces week 3, 10 pieces week 4 etc... I would like to show 15 for week 2, 30 pieces (15+15) week 3, 40 pieces (15+15+10) week 4..

Is this possible

Tobias

 

[Bill Renaud]

Yes. If "Week" is your row data field, and "Pieces" is in the data area of
the pivot table, then double click on the "Sum of Pieces" gray button. The
PivotTable Field dialog box will be displayed. Set the "Summarize by:" list
box to "Sum" (as usual), then pull down the "Show data as:" combo box right
below that and change it from "Normal" to "Running Total in".
--
Regards,
Bill

Hello,

Is there a way that I can get accumulated values in a pivottable. Now I

can see if we make e.g. 15 pieces week 2, 15 pieces week 3, 10 pieces week 4
etc... I would like to show 15 for week 2, 30 pieces (15+15) week 3, 40
pieces (15+15+10) week 4...

 

[Guest]

Thank You!