Hi, im having problem with filtering on 1 to Many relationship, when i do the Policy count it will have the same number through out, any solutions?
Many
One
Many
| RID | Rework Date | Rework Group |
| R-176A02K9100000 | 6/23/2021 | Premium/Remittance Calculation not Accurate |
| R-176A02EP200000 | 4/9/2021 | Premium/Remittance Calculation not Accurate |
| R-176A02E6400000 | 4/15/2021 | Premium/Remittance Calculation not Accurate |
| R-176A0228300000 | 6/2/2020 | Recalled |
| R-176A021H400000 | 6/2/2020 | Recalled |
| R-176A02K9100000 | 5/24/2021 | Local Insured / Broker contact information inaccurate |
| R-176A027L900000 | 10/30/2020 | Local Insured / Broker contact information inaccurate |
| R-176A0278800000 | 10/30/2020 | Local Insured / Broker contact information inaccurate |
| R-176A02K9100000 | 9/15/2020 | Local Insured / Broker contact information inaccurate |
| R-176A02BG500000 | 4/20/2021 | Limits, sub - limits or deductibles missing or incorrect |
| R-176A02AJ000000 | 1/14/2021 | Limits, sub - limits or deductibles missing or incorrect |
| R-176A028Z700000 | 12/17/2020 | Limits, sub - limits or deductibles missing or incorrect |
One
| PID | RID | Rework Count | Rework (U) Count | Policy Count |
| P-206133800 | R-176A01ZR700000 | 0 | 0 | 1 |
| P-205907300 | R-176A01V8300000 | 0 | 0 | 1 |
| P-216718600 | R-176A02DC200000 | 0 | 0 | 1 |
| P-206528700 | R-176A02AR200001 | 0 | 0 | 1 |
| P-206528700 | R-176A02AM300000 | 0 | 0 | 1 |
| P-206528700 | R-176A02AT800001 | 0 | 0 | 1 |
| P-206528700 | R-176A02AV300000 | 0 | 0 | 1 |
| P-206528700 | R-176A02AU500000 | 0 | 0 | 1 |
| P-216771800 | R-176A02C9000000 | 0 | 0 | 1 |
| P-214310200 | R-176A02IQ600000 | 0 | 0 | 1 |
| P-204310200 | R-176A024Y400000 | 1 | 1 | 1 |
| P-206528700 | R-176A02AN100000 | 1 | 1 | 1 |
| P-206528700 | R-176A02AX900000 | 1 | 1 | 1 |
| P-215336600 | R-176A02HP900000 | 1 | 1 | 1 |
| P-205854900 | R-176A01TR400000 | 2 | 1 | 1 |
| P-216771800 | R-176A02C8200000 | 2 | 1 | 1 |
| P-205907300 | R-176A01V9100000 | 1 | 1 | 1 |
| P-205854900 | R-176A01VO800000 | 1 | 1 | 1 |
| P-202787200 | R-176A026U000000 | 1 | 1 | 1 |
