I have created a report which shows for a particular user how many cold calls she has made for a particular product, if this was successful she has sent a brochure and I have another section to show this. At this stage she schedules a call for one of our sales guys, he then calls and hopefully gets a meeting.

I can get a nice graph showing number of calls and brochures emailed, what I can't figure is then how do I show in the same report the number of apppointments for the sales guy for the companies that got sent brochures.

The other factors are I am identifing the calls and brochure sent by including all records that start with certain strings eg "xyz" and "abc", therefore when the meeting is booked this doesn't always have a set text starting it, therefore I don't think any of the apppointments are included in the subset I am processing, I guess I'd be happy with two seperate reports, but I can't figure how to only process a subset of the original database, ie the companies that have been sent brochures.

PM from DBlank

Sorry, this is tough without seeing the actual data... Hope this helps a bit.

I didn't realise I could add a table twice, let me have a play with that. Could you post an example of the data would would expect to see, as I'm a little unsure (ignoring security) what you would need to see. I can then figure how to export this