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"

"Cecilia" wrote:

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

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

Cecilia wrote:
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?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html