View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ChristopherTri ChristopherTri is offline
external usenet poster
 
Posts: 49
Default 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