| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format based on data from another column | Excel Discussion (Misc queries) | |||
| displaying data within column | Charts and Charting in Excel | |||
| Combining workbooks with some variable field names | Excel Discussion (Misc queries) | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Comparing Cells and Displaying Data | Excel Worksheet Functions | |||
Linear Mode
