Excel 2003 Pivot Table - Grand Total

[ray_johnson]

I have a table with the following columns:

Month - Item - Description - Cost1 - Cost2 - Cost3

Every row has an entry in either Cost1, Cost2, or Cost3.

If I make a pivot table with Month in the Row area and Sum of Cost1, Sum of
Cost2, and Sum of Cost3 in the Data area, it will give individual totals by
month of Cost1, Cost2, and Cost3. Is there a way to show BY MONTH the sum of
Cost1, Cost2, and Cost3? I'd rather not add an additional column in my data
if possible.

Checking Grand Totals for Columns only gives individual totals.

Any ideas?

 

[Jim Thomlinson]

You can add a Calculated Field. From the Pivot Table Toolbar select Pivot
Table -> Calculated Field -> Add a name and make the formula Cost1 + Cost2 +
Cost3.

 

[ray_johnson]

Jim,

Thanks! That works great. Is there a way to show only that Calculated
Field, but not the individual Cost1, Cost2, and Cost3?

The best option would be to have a grand - grand total that would sum up all
the months, again, without individual Cost1, Cost2, and Cost3 totals.

 

[Jim Thomlinson]

Under Data just de-select the Cost1, 2 and 3. The calculated field does not
require the costs to be shown.

 

[George Nicholson]

Is there a way to show only that Calculated

Field, but not the individual Cost1, Cost2, and Cost3?

Hide Cost1, Cost2, Cost3. They don't have to be visible for the calculated
field to work, they just have to be in the data.

The best option would be to have a grand - grand total that would sum up
all
the months, again, without individual Cost1, Cost2, and Cost3 totals.

Under table options, make sure "Grand Totals for Columns" is checked.