Sum distinct CustomerID

[#1]

Hi All,

i am sitting with a requirement to write:

the sum of Revenue where Customer ID is equal to Distinct

but have no idea how to tackle this one, any help would be accepted.

Thanks.

[nagarjuna_kotha]

PFA....

[nagarjuna_kotha]

Check Script first and apply same in your script if it is possible .