Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello,
I am a newby to using pivot tables. Is it possible to make a pivot table display cummulative values. If the source of my values is by month, and I want it to dispay cummulative in the pivot table. For instance -- Feb = Jan+Feb, Mar = Jan+Feb+Mar, Apr = Jan+Feb+Mar+Apr......etc. How can I do this? Thanks, |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Perhaps your source data table can have cumulative calculations?
Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "tjh" wrote: Hello, I am a newby to using pivot tables. Is it possible to make a pivot table display cummulative values. If the source of my values is by month, and I want it to dispay cummulative in the pivot table. For instance -- Feb = Jan+Feb, Mar = Jan+Feb+Mar, Apr = Jan+Feb+Mar+Apr......etc. How can I do this? Thanks, |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi TJH,
Dave F's suggestion is a smart one... regards -- ***** birds of the same feather flock together.. "Dave F" wrote: Perhaps your source data table can have cumulative calculations? Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "tjh" wrote: Hello, I am a newby to using pivot tables. Is it possible to make a pivot table display cummulative values. If the source of my values is by month, and I want it to dispay cummulative in the pivot table. For instance -- Feb = Jan+Feb, Mar = Jan+Feb+Mar, Apr = Jan+Feb+Mar+Apr......etc. How can I do this? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUM PRODUCT & CUMMULATIVE BALANCE | New Users to Excel | |||
Plotting Cummulative Data In A Line Graph | Charts and Charting in Excel | |||
A Cummulative List of Formulas | Excel Worksheet Functions | |||
trend chart with cummulative column | Charts and Charting in Excel | |||
cummulative sum | Excel Worksheet Functions |