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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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?
 
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

Totalling Columns in Pivot Charts 1
Referencing a pivot tables Grand Totals Column 1
Pivot Table Column Totals - XL2003 5
I can't see Grand total rows even though the option's switched on 2
Grand Total for Rows not Working in a Pivot Table 1
Grand Totals for Pivot Tables 4
Pivot Table - move Totals column 1
Pivot Table - 3

Back
Top