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.

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.

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.