Pivot Table Column Totals

[Guest]

I have a question on Pivot tables.

I have data in a pivot table with totals being reported for columns not
rows, for example:
Data Column 1 Column 2 Column 3
Column 4
Sales- Store 1, Sales Store 2, Sales Store 3
Total
Title 1, Item No.
Title 2, Item No.
Title 3, Item No.

How can I have the total (Column 4) appear as the leftmost data column?

I want to move the total to the first data column?

Any help is appreciated.

Thanks,

Cecilia

 

[Guest]

Try doing this...

Right click on Column 4 in the pivot table... then go to Order... and select
"Move to Beginning"

 

[Debra Dalgleish]

If this is the total for the rows, you can't move the Total column to
the left of the data columns.