Accumulate data in pivottable

T

Tobias

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
 
B

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


Tobias said:
Hello,

Is there a way that I can get accumulated values in a pivottable. Now I
Click to expand...
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...
 
Top