Hi All, wonder if anyone can help me with a Embeded Chart I have in a report.

I have a lovely report that shows invoices / passenger names / Amounts etc and groups by Passenger Name....

I have added a Graph that shows the group totals for each name, this is working fine.

However, I just want to show the top 5 (ie highest spenders) and not all in the Graph ?

Does anyone know how to do this in the chart??

Also, I would like to add a Sub Report to show the top 10 invoices (by amount).... I have added the sub report but cant figure out how to just have the 10 highest value invoices?

Any help greatly appreciated.

Many Thanks

Miles