I am trying to get an inventory reorder report written for a customer in Sage Intelligence. I have created two containers and two reports that pulls CI_ItemWarehouse and AR_InvoiceHistory Header and Detail. I am trying to pull the two tables together in one report. Easy enough until customer said that they want to show the previous 12 months of sales from invoice history detail. I have attached a screenshot of the outcome they want. This is exactly what they want but I have so many VLOOKUPS in the period sales, the report takes over 30 minutes to run.
Any thoughts?