pivot table_reversing sums and groups

[aspgk]

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

 

[ChristopherTri]

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...

 

[Debra Dalgleish]

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 here:
http://www.contextures.com/xlPivot02.html

 

[Roger Govier]

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

 

[Debra Dalgleish]

Maybe not! It was just a guess. <g>

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