How do I pull specific items from a table by filters, and take that data and put it into a pie chart?

So some progress made, I have it now so my pie chart has the series "Job Type Prefix", and the data values are "Total Price of Job" because we want to see where all our money is coming from. The series gives me the slices "1", "2", and "0". The table is displaying correctly, but I am still missing the primary feature:

I need to split the "1" slice into 2, which would ask the "customer name" and then determine from another table if that customer is an OEM or distributor. So I have 3 slices currently and I need 4.


I'm so sorry and I appreciate your patience.