I need to develop a report that sums commissions by office based on account number.
I've created a field that assigns a "DeptIDMarker" of either "A" or "B". Now what I can't figure out is how to Sum(Commission) where DeptIDMarker = A and then another field to Sum(Commission)where DeptIDMarker = B.
I hope someone can understand and help. I would really appreciate any suggestions.
Thank you.
I've created a field that assigns a "DeptIDMarker" of either "A" or "B". Now what I can't figure out is how to Sum(Commission) where DeptIDMarker = A and then another field to Sum(Commission)where DeptIDMarker = B.
I hope someone can understand and help. I would really appreciate any suggestions.
Thank you.