Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Pivot Table - Grand Total
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Pivot Table - Grand Total
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. -- HTH... Jim Thomlinson "ray_johnson" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Pivot Table - Grand Total
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" wrote: 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. -- HTH... Jim Thomlinson "ray_johnson" wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Pivot Table - Grand Total
Under Data just de-select the Cost1, 2 and 3. The calculated field does not
require the costs to be shown. -- HTH... Jim Thomlinson "ray_johnson" wrote: 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" wrote: 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. -- HTH... Jim Thomlinson "ray_johnson" wrote: 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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Pivot Table - Grand Total
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. -- HTH, George "ray_johnson" wrote in message ... 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" wrote: 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. -- HTH... Jim Thomlinson "ray_johnson" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Grand Total | Excel Discussion (Misc queries) | |||
Pivot Table (Grand Total) | Excel Discussion (Misc queries) | |||
Pivot Table Grand Total | Excel Discussion (Misc queries) | |||
Pivot Table & Grand Total Row & XL 2003 | Excel Discussion (Misc queries) | |||
Grand total in Pivot-Table | Excel Worksheet Functions |