software

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?

quot;sherobotquot; wrote:

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

yes that was it! thank you very much Tim!

quot;Tim Mquot; wrote:

gt; Not 100% sure if I understand the problem but can you drag both the premium
gt; and initial costs into the 'data' area of the pivot table?
gt;
gt; quot;sherobotquot; wrote:
gt;
gt; gt; Can anyone help?
gt; gt; I have a column for my premium cost and a column for my initial cost, but
gt; gt; how do i get the pivot table to display a total for each column. I have 50
gt; gt; rows and three different divisions. So for each division it gives me grand
gt; gt; totals for the premium cost rows and only the individual totals for the
gt; gt; initial cost.