I am stuck... I have tons of data as summarized below. I want to get 4 rows
for each customer. One Row will be the Sum of the NonUS, Next Row, Sum of
US, and then the next 2 rows % of the Revenue from US and NonUS for that
Customer.

I can get the first 2, it is the last 2 that is messing me up. Any ideas?

Cust# COUNTRY DATE REV
10756V NON-US 200807 10
10756V NON-US 200808 20
10756V NON-US 200801 10
10756V US 200709 20

--
Sunny FL