The table showing the ship qty also contains other information such as forecast for the period.
So what I really want to do is to analyze Forecast vs Actual Demand vs Shipped Qty over different time intervals.
Actual demand I need to get from a different table and this is showing demand per date, not per period.
So I have about 30.000 items and 150 periods per item.
I need to show this data for every item and then I will have to aggregate periods to show e.g. YTD, LY, Quarters etc. and calculate forecast accuracy over the time interval and highlight items with low accuracy.
Ideally (I think..) I would want the sum(actual demand qty) joined into the shipqty table.
If you want you can join all the data in the script into one table. Or you can create additional summary tables. But I'd start with giving the users options to make selections so they're not confronted with non-performing sheet objects that try to show 30.000 items over 150 periods at the same time.