Pivot Table Column Totals

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Try doing this...

Right click on Column 4 in the pivot table... then go to Order... and select
"Move to Beginning"
 
If this is the total for the rows, you can't move the Total column to
the left of the data columns.
 
Back
Top