I'm working to create a pivot table and out how to manually set the columns order.

Basically, my data has an "Aging Bucket" column of "Current", "1-30", "31-60, and so on. And also has an "Amount" column next to it as well.

I can great the pivot table and summarize the info by "Bucket", but column order always places "Current" at the far right column of the pivot.

This is a piece of pivot code I was trying as its part of larger script. And I cana post back an example perhaps if needed.
This code 'fails' currently due to trying set a position for the columns though.
Please Login or Register  to view this content.