| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running Total in Pivot Table
Right-Click on the sum of the Total Button, and choose Field settings
Click the Options button From the drop down list "Show Data As" Select Running Total In Base Field select the DATE click Ok. Pick Up : Excel Pivot Tables "Recipe Book" By Debra Dalgleish -- William<"M" Using 2007 "Lee" wrote: I have a Pivot Table in which I want ot create a running total of costs over several years worth of time. The problem I am having is that for each year it resets the running total to zero and starts over again. Is there a way to have excel not do this so that it carries the running total across several years and keeps the running total going??? Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a running total (balance) in a pivot table? | Excel Worksheet Functions | |||
| Pivot table and running total | Excel Discussion (Misc queries) | |||
| Pivot table and running total | Excel Discussion (Misc queries) | |||
| % of running total in pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table - Running Total Annualised | Excel Discussion (Misc queries) | |||
Threaded Mode
