Running Total by Maximum Date

Hi Experts,

I have 2 Group Footers GF1 and GF2...I have a subtotal per each of these...Per detail line I have Various Dates...I need to summarize at the Report Footer the summary by Maximum of the MonthName of the Dates..

01/19/2014
01/14/2014
02/05/2014

I need to have the GF2 subtotal associated with the MonthName of 02/05/2014 and Show a Grand total of that value based on 'February'

Hopefully this makes sense
Michael KatzAsked:
Who is Participating?
 
mlmccCommented:
Try this idea

Add a third group on the date field
You don't need to put anything in the group header or footer except a formula that calculates the group total and saves it in a variable.  You can then display the total (through the variable) in the next group footer

mlmcc
0
 
mlmccCommented:
WHat are your groups?

How is the group total different from the value associated with the date?

mlmcc
0
 
Michael KatzAuthor Commented:
Group 1 is a Salesperson
Group 2 is a SalesOrder

The Group 2 is not a date field...I currently have a summary on a date field to give me the Maximum(Date) and it resides on the GF2 line
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
Michael KatzAuthor Commented:
Maybe the best solution is just to create a subreport based a group of The Max Podate
0
 
mlmccCommented:
Do you need the details from the other dates?

mlmcc
0
 
Michael KatzAuthor Commented:
Yes...I need the details from the other dates
0
 
James0628Commented:
Are you trying to get a single total in the report footer for the latest date (Month?) on the report, or something else?

 James
0
 
mlmccCommented:
In the problem statement he needs it in GF2.

mlmcc
0
 
James0628Commented:
Actually, in the first part of his first post he says "I need to summarize at the Report Footer", and then near the end says "Show a Grand total".  So, I'm really not sure what he's looking for.

 James
0
 
Michael KatzAuthor Commented:
Hi guys,

I just created a subreport...works
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.