Expression for Peer Group Sales

[zagzebski]

I need to know what the expression for Peer Sales would be. Basically gettting sales for all customers except the customer line you are on.  Customer A has sales of 10, peer sales of 50 (B+C),  Customer B has sales of 20, with peer sales of 40 (A+C), etc.

Customer	Sales	Peer Sales
A	10	50
B	20	40
C	30	30

Thanks in advance,

Zag

[maxgro · Accepted solution]

Sum(Total Sales) - sum(Sales)

[sunny_talwar]

May be this for Peer Sales

=Sum(TOTAL Sales) - Sum(Sales)