Summary tables and Currency

Hi all,

I have a Summary table which rolls up the totals of data that's added to a table called 'Opportunity Products'. Each line of data will have a 'Total price' added to it, but the addition depends on where it has been added from (UK/EU/US) so therefore data is added in three currencies. This poses a bit of an issue in providing summaries as I would love to just have the total figure of all of the revenue rather than split out by currency.
Is there an easy way to tackle this which doesn't alter the structure of my data too much?