how do i total more then one category for each column in a pivot t
 

Can anyone help?
I have a column for my premium cost and a column for my initial cost, but
how do i get the pivot table to display a total for each column. I have 50
rows and three different divisions. So for each division it gives me grand
totals for the premium cost rows and only the individual totals for the
initial cost.

how do i total more then one category for each column in a pivot t
 

Not 100% sure if I understand the problem but can you drag both the premium
and initial costs into the 'data' area of the pivot table?

"sherobot" wrote:

Can anyone help?
I have a column for my premium cost and a column for my initial cost, but
how do i get the pivot table to display a total for each column. I have 50
rows and three different divisions. So for each division it gives me grand
totals for the premium cost rows and only the individual totals for the
initial cost.

how do i total more then one category for each column in a piv
 

yes that was it! thank you very much Tim!

"Tim M" wrote:

Not 100% sure if I understand the problem but can you drag both the premium
and initial costs into the 'data' area of the pivot table?

"sherobot" wrote:

Can anyone help?
I have a column for my premium cost and a column for my initial cost, but
how do i get the pivot table to display a total for each column. I have 50
rows and three different divisions. So for each division it gives me grand
totals for the premium cost rows and only the individual totals for the
initial cost.