Hi

I am using the runningtotal() function and I can't get it to work exactly as I want it. I have a column of countries, corresponding suppliers and amounts spend with each supplier in each country. I have aggregated the the table by country, supplier and um of amount and ordered it by country (asc), amount (desc) so the results look like this:

UK, M&S, 1000
UK, IBM, 950
UK, Tesco, 850
Germany, VW, 2000
Germany, Audi, 1950
Germany, Mercedes, 1800

I want to put a running sum on this aggregated view so it sums the amounts in spend order eg:


UK, M&S, 1000, 1000
UK, IBM, 950, 1950
UK, Tesco, 850, 2800
Germany, VW, 2000, 2000
Germany, Audi, 1950, 3950
Germany, Mercedes, 1800, 5750

When I so the runningtotal I can't get it to sum in the correct order. How can I do this?

Thanks

Andy