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!

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

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