I am trying to add the amount rows to get the total amount per ID, if the ID term and type match. Here is what I have: ID term amount type 1828111 2019FA -859 110131 1828111 2019FA 859 110131 999999 2019FA -3108 170125 999999 2019FA 3108 170125 8888888 2019SP -14550 130133 8888888 2019SP 14750 130133 Here is what I would like ID term amount type 1828111 2019FA 0 110131 999999 2019FA 0 170125 8888888 2019SP 200 130133
... View more