Get SUM of Amount based by remove the duplicate id
From the below table I want to sum collection amount based on the unique Opportunity-ID. If there are two duplicate opp ids I need to consider one row to count the sum.
Note I cannot remove the duplicate rows as these rows merged with another table which I need to build another report.
I am creating this report in Pivot table and I need to segregate the report by website..
Ex opp id: 480857000007805015
| Website |
Created Time |
Collection Amount |
Collection Date |
Collection value Rep |
|
Opportunity-ID |
| domain1 |
07/14/2023 09:22 AM |
Rs.1,500.00 |
07-14-2023 |
Rs.1,424.66 |
|
480857000010669000.00 |
| domain2 |
06-08-2023 14:53 |
Rs.1,500.00 |
06-12-2023 |
Rs.1,500.00 |
|
480857000008994000.00 |
| domain5 |
05/17/2023 08:10 AM |
Rs.1,600.00 |
05-25-2023 |
Rs.825.00 |
|
480857000007815000.00 |
| domain7 |
06/22/2023 03:45 AM |
Rs.1,500.00 |
06-22-2023 |
Rs.1,500.00 |
|
480857000007805000.00 |
| domain8 |
05/31/2023 01:52 PM |
Rs.1,500.00 |
05-31-2023 |
Rs.1,900.00 |
|
480857000007805000.00 |
| omain9 |
05/16/2023 09:28 AM |
Rs.1,500.00 |
06-05-2023 |
Rs.1,500.00 |
|
480857000007642000.00 |
| domain10 |
05-11-2023 17:23 |
Rs.1,500.00 |
05-23-2023 |
Rs.956.00 |
|
480857000007608000.00 |
| domain11 |
04/28/2023 05:41 PM |
Rs.1,500.00 |
05-01-2023 |
Rs.1,500.00 |
|
480857000007180000.00 |
| domain12 |
04/27/2023 10:25 PM |
Rs.1,500.00 |
03-31-2023 |
Rs.1,500.00 |
|
480857000007175000.00 |
| domain13 |
06-01-2023 04:43 |
Rs.1,500.00 |
05-31-2023 |
Rs.1,500.00 |
|
480857000006993000.00 |