Forecast Value Not Showing When Dates Do Not Match in 2 Tables

[o59393]

Hi all

I have 2 tables (base forecast and orders) related to each other by the combination Country - Material ID - Date

The table orders not necessarily will have an order/value in each month for the respective country and material ID, while on the table base forecast there will always be a value for the respective Country and Material ID in each month of the year.

For example the table order for the material ID 1841476 and Ecuador I have orders for June, July, September, October and December.

And the table base forecast for the material ID 1841476 and Ecuador has a forecast/value in each month of the year.

With that being said, the problem I face is that my table below will show only the forecast/values for the months where there is an order placed:

If I put the missing date for the respective country and material ID in the table order, as an example Jan, Feb and March:

Then the forecast values will show up on the table:

How could I make the table above show the values in each month for the forecast column despite not having an order and without having to place manually the missing months like above?

Thanks.

[Ashish_Mathur]

Hi,

Your question is not clear.  Share data in a format the can be pasted in an MS Excel file and show the expected result.