HiI really need help with a query I need to create. The data I have currently has an clientid, a service to which he in linked, either with an unassigned value or an active value, and then the current broker , example
client1, insurance, active, broker1
client1, medical, unassigned, null
client1, investments, active, broker2
We are bring this through on a bar chart, the issue now is that where the 3rd column is unassigned, we want to show all possible brokers linked to a client, ie have broker1 and broker2 showing on a bar chart as possible brokers for the unassigned service. What is the best way to do this?
