Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sum(Total Sales) - sum(Sales)
Sum(Total Sales) - sum(Sales)
May be this for Peer Sales
=Sum(TOTAL Sales) - Sum(Sales)