Author Topic: Looking for Minimum Date where all other data is the same  (Read 2664 times)

Offline eekanif

  • Associate
  • **
  • Join Date: Oct 2010
  • Posts: 1
  • Forum Citizenship: +0/-0
Hey there gang.
I'm building a report consisting of employee name, address, and number information and job codes, where the request is to return only the job code for the most recent start date. 

In most cases the employee information and job code remains static - returning multiple line items per employee based on variations in the start dates.

I thought I could summarize (advanced) at the row level, looking for the "latest" start date, but QS only allows me to look for latest date in the footers, not in the rows themselves.

I can't filter...

I tried calculating for "latest" but then it wants to compare it against the system date, which does me no good.

Is there any way around this?

Offline RKMI

  • Community Leader
  • *****
  • Join Date: Sep 2012
  • Posts: 248
  • Forum Citizenship: +19/-0
Re: Looking for Minimum Date where all other data is the same
« Reply #1 on: 08 Jan 2013 11:19:40 am »
Hi,

Having a similar issue any thoughts on this experts?

Thanks,
RK
"Inflexibility comes from lack of imagination" ~ RK

 


       
Twittear