Accumulate data in pivottable
 

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

Accumulate data in pivottable
 

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" wrote in message
...
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

SV: Accumulate data in pivottable
 

Thank You!