Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
Cumulative Totals
 Login/Join
 
Member
posted
I am trying to write a report that will give monthly and ytd totals across month. The user will input the last day of the month. Here is a sample of what I want:


Name Month
Jan Feb Mar
MTD YTD MTD YTD MTD YTD
John Doe 10.00 10.00 10.00 20.00 10.00 30.00
Jane Doe 15.00 15.00 10.00 25.00 20.00 45.00
(It's not keeping my spaces, so you'll have to imagine what it should look like.)

The YTD field need to be cumulative and I cannot figure it out. Help!!!

Confused
 
Posts: 25 | Location: Kingwood, Tx | Registered: May 06, 2003Reply With QuoteReport This Post
<gary>
posted
Victoria, I have done reports with cumulative totals. I would need to see what your MFD looks like to show you what you would need to do. Please, provide a sample of your MFD.

Thanks...

Gary
 
Reply With QuoteReport This Post
Member
posted Hide Post
Gary,

Thanks so much for your reply. I figure it out this morning when I came in. I guess a 3 day weekend works wonders!

Razzer
 
Posts: 25 | Location: Kingwood, Tx | Registered: May 06, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 


Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.