Jump to content

Using Two Tables - Create "Dynamic Calculated Column"

Alex Robles

Recommended Posts

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...