Showing results for 
Search instead for 
Did you mean: 

change order of column aggregation in pivot

9 - Travel Pro
9 - Travel Pro

Im looking for way of changing order in which column are aggregated in pivot table.

Below you will currently what I have. I have month numbers first and for each month I have Primary and Comparison Value.

column order.PNG

What client is looking for is to have Primary Value columns 1 to 6 columns , then Comparison Value 1 to 6 columns. So have all columns for 1st Value then all columns for 2nd Value. Column number can vary so cannot hardcode each value separately.

Is this possible to achieve with a script?