Get sum by filtering on two columns

amitsingh88

I need to print the sum of all total investment values in 2016 (TIV_2016), to a scale of 2 decimal places, for all policy holders who meet the following criteria:

1. Have the same TIV_2015 value as one or more other policyholders.
2. Are not located in the same city as any other policyholder (i.e.: the (latitude, longitude) attribute pairs must be unique)

I tried this with no success.

Also suggest the Python script to get the result if possible.

Please help.

Thanks

Example.yxzp

atcodedog05

Hi @amitsingh88 

Sorry, misread the condition. Here is how you can do it.

Workflow:

Hope this helps : )

Example.yxmd