YUAN_DUMALE
New Member
- Joined
- Oct 23, 2014
- Messages
- 11
Hi,
I am currently working on a report. And what i wanted to do was to add all the amount paid in one row per Employee ID.
Please refer below:
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Output should be:
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Needed to use macro for this one.
Thanks in advance! ^_^
I am currently working on a report. And what i wanted to do was to add all the amount paid in one row per Employee ID.
Please refer below:
Employee ID | Company | Employee Name | Applicable Month | Claim Type | Amount Paid |
1235 | test | Doe, John | April | Education | 100.00 |
1235 | test | Murdock, Frank | April | General Utilities | 987.00 |
1241 | test | Santos, May | April | Wellness & Welfare | 500.00 |
1234 | test | Cruz, Juan | April | Travel and Holidays | 599.00 |
1241 | test | Santos, May | April | Travel and Holidays | 658.00 |
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Output should be:
Employee ID | Company | Employee Name | Applicable Month | Claim Type | Amount Paid |
1235 | test | Doe, John | April | Education | 1087.00 |
1241 | test | Santos, May | April | Wellness & Welfare | 1158.00 |
1234 | test | Cruz, Juan | April | Travel and Holidays | 599.00 |
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Needed to use macro for this one.
Thanks in advance! ^_^