Model Connection Not showing the Correct Bar Chart Values

[hctrgrc]

Hello, I'm trying to display data from two tables. 1) My main table with historical sales in volume is based on Sales representatives. and 2) A forecast table with a single month with the corresponding volume for each sales representative. I have the names of the S.R. (sales representatives) on both tables and I join them with a [1 to many] connections as the historical data has many SR and my forecast table only has a few. 

I then simply graph each of the SR in a clustered bar chart (from the main [1] table, and then I want to add the forecast volume for each SR as a model relationship has been made already . The problem is when I add to the bar chart my forecast volume, it is displayed for every SR as the total volume amount of the forecast table instead of the corresponding value for each SR. I then get the option to display it as the "Count" or the "Sum" of the values but nothing helps to display it correctly. 

Is there a way around this? I've tried to look into the type of data my forecast table is showing but it all seems to show whole numbers (no text or different type of format). 

[lbendlin]

These tables should not be linked directly. Instead they should both be controlled by dimension tables for Sales Rep and Calendar etc.