How to add a column of accumulated data in pivottable?

A

Angus

For example, the first column in data field is selling amount, how to make
second column as accumulated selling amount in pivot table?

Selling Accumulated Selling
10 10
15 25
7 32
 
C

cs02000

Piece of cake

In the data area of the pivot table wizard, enter the “Sales” field
twice.

Make sure both are set to “Sum”

On the second instance of “Sum of Sales” probably called “Sum of Sale2”
by now.....
change the “Options” to running total.
 
Top