Sum Columns in a Pivot Table

J

Jim

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?

Thanks
 
S

smartin

Jim said:
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?
Click to expand...

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