Using Two Tables - Create "Dynamic Calculated Column"

[Alex Robles]

My apologies because I am very new to this and I don't know if I am asking this question in the right way. Here is my attempt.

 

I have tables that I am getting from two places. One inlcudes sales history for the last 3 years.

The other has inventory level information.

 

What I am trying to do is create a way to visualize and forecast sales by model and take into consideration current and pending inventory levels. I have added an illustration that I created to show what I am trying to accomplish. I have everything made except the way to subtract my "Current Inventory" from my "Forecast".

I have filters on the side to narrow this down to specific makes and models.

The other nice thing would be able to know how to look at it from the "Current Date" going forward in time on a rolling 12 months. And broke down by month.

 

Any thoughts on this would be very helpful.

Thanks in advance.