How to extract policy basis on Net sum

[prpanw]

Hi Folks,

I have databaset where Policy numbers and net amount in the sheet. How to extract those polcies where sum of net is 0 but  Same policy can have multiple rows with Net amount and it could be cross match. for example below policy has 3 rows where 2nd and 3rd sum is 0. So I need that rows. it can match 1st and 3rd row as well.

Poliyc      Net

A                299

A                  99

A                -99



 

[binuacs]

@prpanw one way of doing this with the cross join 

[Qiu]

@prpanw 
By Cross match, you mean for the example below, " 99" can be matched twice with "-99"?

Poliyc      Net

A                299

A                  99

A                -99

A                -99