This project has moved. For the latest updates, please go here.

Pivot table column Labels order

May 4, 2012 at 2:58 PM

Sweet product.

I've added a column to my pivot table
I've set the data to display by columns
pivotTable1.DataOnRows = false;

When I open in Excel and view the field list, my new column that I created displays first in the "Column Labels" section followed by the "Values".

For presentation I would like the "Values" to be first and my new column to be 2nd. Can you tell me if I can control this and how.