pivot table_reversing sums and groups
 

1. Is there a way to create a pivot table where the sums are in the columns
and the groupings are in the rows...?

Please advise and thanks

Paul

pivot table_reversing sums and groups
 

Not sure what you are trying to accomplish, a little more information would
help.

Right clicking on the field labels in the pivot table and selecting "field
settings" will allow you to turn the sum function for the field on and off.

Adding a duplicate column of data to the source data for the pivot table
might also help you.

Regards...


"aspgk" wrote:

1. Is there a way to create a pivot table where the sums are in the columns
and the groupings are in the rows...?

Please advise and thanks

Paul

pivot table_reversing sums and groups
 

After you add the fields to the pivot table's data area, drag the Data
field button to the right, onto the cell that contains the word 'Total'.

There's a picture he
http://www.contextures.com/xlPivot02.html


aspgk wrote:
1. Is there a way to create a pivot table where the sums are in the columns
and the groupings are in the rows...?


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

pivot table_reversing sums and groups
 

Aaaah.....
Thank goodness somebody understood the question <bg
Well done Deb!

--
Regards

Roger Govier


"Debra Dalgleish" wrote in message
...
After you add the fields to the pivot table's data area, drag the Data
field button to the right, onto the cell that contains the word
'Total'.

There's a picture he
http://www.contextures.com/xlPivot02.html


aspgk wrote:
1. Is there a way to create a pivot table where the sums are in the
columns and the groupings are in the rows...?


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

pivot table_reversing sums and groups
 

Maybe not! It was just a guess. <g

Roger Govier wrote:
Aaaah.....
Thank goodness somebody understood the question <bg
Well done Deb!



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