How to calculate total distinct income

Hello All,

Here is the dataset and I would like to visualize the total distinct income generated for the distinct id’s w.r.t the site.

ID status income site
123 failed 1000 Site A
123 paid 1000 Site A
456 paid 2000 Site B
678 paid 400 Site C

I tried sumOver function by calculating the sum(income) over ID and site but I wanted the distinct income.

So I calculated sumOver(max(income),[id,site]) but I also need to calculate the sum of total income for different sites month wise. Can anyone help me with this.

Thank you!!