User Profile
vikash1984
Former Employee
Joined Jul 26, 2022
User Widgets
Recent Discussions
Merge and Sum unique values linked to repetitive ID
Hello, I need help with the following task in hand. Need to sum amount paid through same cost center and show the total amount in 1 row instead of multiple rows by EE ID. Sample Data EE ID Cost Center Amount Paid 123456 987654 500 123456 987654 2100 123456 987654 3000 123456 653214 2000 132646 321004 1100 236789 324567 2700 236789 324567 1800 236789 324567 2100 236789 324568 1800 236789 324568 1100 231678 987654 500 Desired Result EE ID Cost Center Amount Paid 123456 987654 5600 123456 653214 2000 132646 321004 1100 236789 324567 6600 236789 324568 2900 231678 987654 500 Thanks in advance!Solved2.7KViews0likes5Comments
Recent Blog Articles
No content to show