Pivot Table Column Totals

C

Cecilia

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
 
A

AKphidelt

Try doing this...

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

Debra Dalgleish

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top