| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Need to Add Column to Data in Pivot Table | Charts and Charting in Excel | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Linear Mode
