Hi, I want to combine the amount paid on the table below. However, I am planning to filter it first by employee ID then by claim type. Please refer below: Employee ID Company Employee Name Applicable Month Claim Type Amount Paid 1234 test Cruz, Juan April Travel and Holidays 923.00 1234 test Cruz, Juan April Wellness and Welfare 646.00 1234 test Cruz, Juan April Savings and Investment 1250.00 1235 test Doe, John April Education 100.00 1235 test Doe, John April Education 100.00 1235 test Doe, John April Savings and Investment 500.00 1235 test Doe, John April Wellness and Welfare 600.00 Output should be: Employee ID Company Employee Name Applicable Month Claim Type Amount Paid 1234 test Cruz, Juan April Travel and Holidays 923.00 1234 test Cruz, Juan April Wellness and Welfare 646.00 1234 test Cruz, Juan April Savings and Investment 1250.00 1235 test Doe, John April Education 200.00 1235 test Doe, John April Savings and Investment 500.00 1235 test Doe, John April Wellness and Welfare 600.00 Thank you so much in advance. ^_^

combining data using 2 filters

Hi,

I want to combine the amount paid on the table below. However, I am planning to filter it first by employee ID then by claim type.

Please refer below:

Output should be:

Thank you so much in advance. ^_^

combining data using 2 filters

combining data using 2 filters