Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running Total in Pivot Table
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running Total in Pivot Table
It depends what you're using a base field, but if you're doing a running
total by year and month, perhaps you could add a new field to the source data. In that field, calculate the year and month, e.g.: =TEXT(A2,"yyyy-mm") Add that field to the pivot table, and use it as the base field for the running total. 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, -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#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, |
Reply |
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) |