This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
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?
