Forum

Can PQ add Table Co...
 
Notifications
Clear all

Can PQ add Table Columns rather than Sheet Columns?

2 Posts
2 Users
0 Reactions
109 Views
(@mikenwb)
Posts: 1
New Member
Topic starter
 

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.

 
Posted : 09/09/2017 5:20 pm
(@catalinb)
Posts: 1937
Member Admin
 

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

 
Posted : 11/09/2017 12:43 am
Share: