Hello, I’ve created the base below with sample data. Each Project has two Clients assigned to it. Each Client receives two payments. These two payments may or may not be made within the same calendar year. I have been able to sum up the “paid” and “o...

I am trying to summarize data that I can display in a chart. I have a table of projects with a column for clients assigned to the projects. Two separate payments are made to each client for each product. I am tracking whether the payment has been “pa...