How to create charts with unique data

Hi amitchandak  

Thanks for your replay

here the problem is , if you see in below image , there i am using  one work order id,after choosing that it shows related data . In left side table you can see 5 persons are (invovled) using that work order but the work order manager is one person which is " harsha". Now when i choose the id in 2 nd bar chart shows all people with same values because those are invovled or used but they are not managers of that . when i choose id at that time i need only manager data and that should be the output other people are not required in the visual. How can i restrict them in visual level . i hope u understand now

can u please help me on this 

please find below image

this is the relationship status 

please check  and help me 

Thanks in adavance