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:
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!!!
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 so much for your reply. I figure it out this morning when I came in. I guess a 3 day weekend works wonders!
|Powered by Social Strata|