Hello all, I apologize in advance if this question seems rudimentary.

I have a pie chart that has a count of products sold. I have set up master-child relationship so when a user selects a slice of the pie, a product/brand table renders and shows the brands of the counts of the products sold (from the pie chart). Now, I want to add a third table that listens from the product/brand table to see a more lower level description of that brand e.g. where the supply is coming from, the appointed sales person, etc. I have tried to incorporate the 3rd level master child relationship, but it is not behaving as I was expecting. I am beginning to wonder if this is even possible in OBIEE.

Any answers will be greatly appreciated. Thank you!