Here is a sample of what I would be looking for:
AccountNumber Client Dollar Output
1005001 ClientA 25000 >10,000
1005001 ClientA 25000 >5,000
1005001 ClientA 25000 >1,000
1005020 ClientB 11000 >5,000
1005020 ClientB 11000 >5,000
1006010 ClientC 1200 >1,000
Thank you for your help on this...