View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
smartin smartin is offline
external usenet poster
 
Posts: 915
Default Sum Columns in a Pivot Table

Jim wrote:
Hello,

Is there a way to sum columns in a Pivot Table (between the additional
columns of data I add)? Without having to use multiple pivot tables?


Hi Jim,

A couple thoughts...

One, pivot tables can be made to show column totals automatically.

Two, GETPIVOTDATA might be what you need if you want to obtain the
collective sum of certain columns.