Power Pivot: How do I fix my One>Many>One>Many relationship to properly filter?

[ez08mba]

Sorry for my crude and cryptic question title. It was hard to phase it. I'm attempting the following in POWER PIVOT. Due to data sensitivity, I can show you the tables but I cannot the Pivot. I'm not too fluent in data tables and relationships, other wise, this may be a commons issue I just don't know how to fix from not having much experience.

Intent behind Relationships:

• Table 8 are InterfaceIDs of TableINT with duplicates removed to create a one-many link between them. The InterfaceID will be the starting point in Pivot filtering always.
• TableINT contains multiple of those IDs
• TableINT and AB both have multiple duplicate Inbound Paths
• KEY is a unique list of all the Inbound Paths linking TableINT to AB
• AB contains these multiple Inbound Paths associated to particular Channels

So we have One-Many | Many-One-Many or... the plan is ID > Path > Channels (and whatever else I need from table AB associated to the Path)

Problem:
I can get the Pivot to filter to only the Inbound Paths associated to that ID. However, I cannot get the Pivot to filter only those Channels associated and unique to their particular Inbound Paths - it simply list all Channels for every Path. Are my relationships wrong? Maybe I need to set the fields differently?

I'm looking to return value associations. I'm not looking for total on anything like channels, ids, etc.

Example:
ID
- Path
- All Channels...
- Path
- All Channels...
ID
- Path
- All Channels...
ID
- Path
- All Channels...
- Path
- All Channels...
- Path
- All Channels...

 

[RoryA]

You have to have a value field, or the relationships will not apply any filtering.