Hi,

I have employee sales records that are currently grouped by:  Region à District à Store à Employee Name.  The records are then sorted by sales date at the employee name level.   I also have a parameter that lets you select which time period you would like (?DateRange).  The problem I’m running into is that if an employee moves then they’ll appear under different store numbers. 

Is there any way to write a record select formula so that each employee’s sales records will be grouped based on the max value of the DateRange parameter?  For example:

In 200601, Jane was located in:

Region: New York

District:  Pittsburgh

Store: 2222

Is there anyway to have the records grouped/sorted so that all of Jane’s records fall under Pennsylvania, Pittsburgh, Store 2222 if the DateRange parameter values are 200601 – 200603?

Basically the store that falls under the max value of DateRange parameter will get credit for all earlier sales.