For some reason I am not able to link an inventory cross table with the regular table (perhaps a loading issue).
The first table (worksheet) shows the products and the expected inventory levels at that point in time.
The second table (worksheet) shows products, quantity and date of arrival.
I would like to compare my receipts and the inventory balance over time to make a very simple graph that can drill down the dates (month to weeks to days) - no problem if I need to make a separate link table just to link the dates with months and weeks.
I tried it over the last few days and could not reach a solution.
Please, help me. Attached is a sample of the data I am using.