Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculated field in Pivot Tables
New to pivot tables, trying to add as a final column, the total of preceding
colums, on a row-by-row basis. Can't get my head round what the source data wil be as all I want is the total of the other fields/columns. All help/comments gratefully received! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculated field in Pivot Tables
The answer to this could be one of two things depending on the question, do you want to 1) Total columns of data, or 2) do you want to total many data items 1) To total columns of data, select Pivot Table options and select Grand Total for Rows 2) To total many data items, Select View, Toolbars and make sure that the Pivot Table toolbar is selected. On your pivot table, click on the field name heading for the columns. From the Pivot Table toolbar, click on Pivot Table | Formulas | Calculated Item. Make sure the column field is still highlighted in the left pane, highlight Formula1 in the Name field and type Total. Then click on each field you want to include in the total in the right pane (Items:) and click on insert item. This should now move this field into the Formula: bar. Edit this formula now, by clicking at the end of the word and type a '+'. Then click on the next item in the right pane (Items:) and click on insert item. This should now move this field into the Formula: bar. Click OK and you should now have your new field in your pivot table, which is the total of all the data items. G -- Gary Brown ------------------------------------------------------------------------ Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084 View this thread: http://www.excelforum.com/showthread...hreadid=536769 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculated field in Pivot Tables
Perfect answer which works perfectly! Thanks.
"Gary Brown" wrote: The answer to this could be one of two things depending on the question, do you want to 1) Total columns of data, or 2) do you want to total many data items 1) To total columns of data, select Pivot Table options and select Grand Total for Rows 2) To total many data items, Select View, Toolbars and make sure that the Pivot Table toolbar is selected. On your pivot table, click on the field name heading for the columns. From the Pivot Table toolbar, click on Pivot Table | Formulas | Calculated Item. Make sure the column field is still highlighted in the left pane, highlight Formula1 in the Name field and type Total. Then click on each field you want to include in the total in the right pane (Items:) and click on insert item. This should now move this field into the Formula: bar. Edit this formula now, by clicking at the end of the word and type a '+'. Then click on the next item in the right pane (Items:) and click on insert item. This should now move this field into the Formula: bar. Click OK and you should now have your new field in your pivot table, which is the total of all the data items. G -- Gary Brown ------------------------------------------------------------------------ Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084 View this thread: http://www.excelforum.com/showthread...hreadid=536769 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculated field in pivot tables | Excel Discussion (Misc queries) | |||
Pivot Tables - how do I add in calculated fields? | Excel Worksheet Functions | |||
Pivot Tables - How do I add Functions as a Calculated Field? | Excel Discussion (Misc queries) | |||
Calculated Field in Pivot Table Based on Two Counted Fields | Excel Discussion (Misc queries) | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions |