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