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

G

Guest

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

Guest

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?
 
G

Guest

yes that was it! thank you very much Tim!

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referencing a pivot tables Grand Totals Column 1
Totalling Columns in Pivot Charts 1
Grand Total for Rows not Working in a Pivot Table 1
Pivot Table Column Totals - XL2003 5
I can't see Grand total rows even though the option's switched on 2
How do I perform extended calculations in a Pivot Table in Excel 2 4
Pivot Table - 3
Column Heading on each row in pivot table 1

Top