PowerPivot relationship not working

[BJaremco]

I have 3 simple tables in a single workbook. Sites table, is the dimension table with "sitecode" as the key relating the other 2 tables, Storage and Servers.

When i pivot sites and storage or sites and servers it works as expected. However when i try to pivot all 3 i get every occurance of storage in each occurance of server. Shouldn't that work? Shouldn't i be able to display just the items of storage and server where the sitecode matches whats in the Site table?

 

[tusharmehta]

I think you should also look into =RELATED() it may work for you.

 

[Matt Allington]

As long as you only place columns from your site table in the pivots, it will work. You can't put a column from storage or server in the pivot and have it influence the other 2 tables. Filters only flow from the dimension table to the fact table.