ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to add a column of accumulated data in pivottable? (https://www.excelbanter.com/excel-worksheet-functions/55731-how-add-column-accumulated-data-pivottable.html)

Angus

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



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.


All times are GMT +1. The time now is 11:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com