Script only works when run step-by-step
Names Default to Here(1);
Query = current data table();
Query_piv = (Data Table( "SO Query" ) << Tabulate(
Add Table(
Column Table(
Grouping Columns( :Year, :Week ),
Analysis Columns( :QTY Ordered )
),
Row Table(
Grouping Columns( :Item, :Item Description, :Channel, :Product Type )
)
)
));
Query_tab = Query_piv << Make Into Data Table;
Query_piv << close window;
Col_Start =
...