Hello,

I'm running into a problem with a calculated field in my powerpivot. I have relationships built for Client ID from two separate data sources(Table2 and Table3) both linked to the master list (Table1). My row labels are from the master list. I'm trying to add the gross sales numbers from Table2 and Table3 but I'm only getting values from Table3. I'm using
Formula: copy to clipboard 
Please Login or Register  to view this content.

Any ideas why this might not be working?