Martin James

Martin James

  • 2k
  • 96
  • 3.1k

Calculate cost per group and show it only in the first row

Mar 18 2021 7:45 PM
I an employee which went to 3 clients I want to add the cost of his journey but want to show it only at his first journey ,the total cost.
Current output : 
Employee Customer  cost
A              1                200
A              2                400
A              3                 100
B              1                 200
 
Expected output : 
 
Employee Customer cost
A          1                   700
A          2
A          3
B          1                    200
 
 

Answers (1)