I need to generate a report whereby, for every invoice, there needs to have been a call in the previous month (to calculate conversion rates). I have got all of these listed, however it generates over 500k records for the date ranges I'm after.

 

I want to be able to running total each record per GH (which is invoice #) so I only select the first record - so basically all I need is one instance of a call, not 100's in some cases. However creating a running total means I cannot use the select expert on it.

 

Does anyone have any ideas?

 

Thanks,

 

Ian

 

Thanks for this, but I already have tried supressing  the data - I want to exclude all the extra records without just running all of them and supressing ones I dont want.