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.
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?
