Hi,

I've been asked to break down the Amount field of an Opportunity into our different business areas but I'm struggling with how to do it.

Each of our products has been marked with the correct Billing Area - Eg. Production, Service etc and I want to Create a field on the Opportunity that just adds up anything in that Opportunity that is marked as Production and then another field to add up anything that is marked as Service but I am really struggling!  I thought it would be simple to do but unless I'm mising something due to the fact it's Friday afternoon I'm really stumped in this one!!

Any help or guidance in the right direction would be greatly appreciated.