How to add a column of accumulated data in pivottable?
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 |
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. |
All times are GMT +1. The time now is 11:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com