Table Relationships

[WxShady13]

I have 2 tables (Table6 & Prototype) from an Excel workbook. I have a Many to many relationship based on Week # on both tables but the Terms (on Prototype) only adjusts down to 1274 regardless of week or region that is selected on the filter (from Table6 Region field). If I use the Prototype Region field the Terms will update but not the HC. How can I adjust the relationship so that the Terms & HC both update correctly?

 

[C Moore]

Make a new column in both that is Terms & HC =[Terms] & " " & [HC]. Use this as your relationship, now a two item relationship.

 

[WxShady13]

The Table6 only has Headcount, while Prototype has the actual Terminations.

 

[C Moore]

Create a date table and make them both dependent on it. Be sure and use the date table as thefilter/selection on the visual.