Thread
:
How to add a column of accumulated data in pivottable?
View Single Post
#
2
cs02000
Junior Member
Posts: 23
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.
Reply With Quote
cs02000
View Public Profile
Send a private message to cs02000
Find all posts by cs02000