I made a PQ that tracks my inbound shipments and its product plus several forecasting averages and variances etc. I am using a series of merges and indexes so that the number of columns in the order section changes based on the number of shipments I have coming in. Every time my number of shipments increases it adds columns to the Excel sheet and I am wondering if there is a way to have it only increase the number of columns in the Table rather than the sheet. I have another small table above it that gives order status for each shipment but it is split by the added shipment columns the PQ is adding.
Hi Michael,
The only way is to put the tables side by side or in different sheets, there is no way to change the default background behavior, those settings are inaccessible.
Catalin