Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grand Totals for Pivot Tables
I have a Pivot Table based on a Table that consists of the following fields:
Provider, Date, Pmt1, Pmt2, Pmt3, Pmt4 When I create the Pivot Table using the Insert-Pivot Table feature I specify Provider and Date as Row Labels and Sum of each of the Pmt fields as values. The resulting table has a Grand Total at the bottom for the columns but I cannot get a Grand Total for the rows at the right. When I the Totals & Filters tab under Pivot Table options both Grand Total boxes are checked. Is there a way the get both Grand Totals at the same time. Any advice would be greatly appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grand Totals for Pivot Tables
Just to Clarify I'm Using Excel 2007
"ExcelPeter218" wrote: I have a Pivot Table based on a Table that consists of the following fields: Provider, Date, Pmt1, Pmt2, Pmt3, Pmt4 When I create the Pivot Table using the Insert-Pivot Table feature I specify Provider and Date as Row Labels and Sum of each of the Pmt fields as values. The resulting table has a Grand Total at the bottom for the columns but I cannot get a Grand Total for the rows at the right. When I the Totals & Filters tab under Pivot Table options both Grand Total boxes are checked. Is there a way the get both Grand Totals at the same time. Any advice would be greatly appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grand Totals for Pivot Tables
I have the exact same problem
"ExcelPeter218" wrote: Just to Clarify I'm Using Excel 2007 "ExcelPeter218" wrote: I have a Pivot Table based on a Table that consists of the following fields: Provider, Date, Pmt1, Pmt2, Pmt3, Pmt4 When I create the Pivot Table using the Insert-Pivot Table feature I specify Provider and Date as Row Labels and Sum of each of the Pmt fields as values. The resulting table has a Grand Total at the bottom for the columns but I cannot get a Grand Total for the rows at the right. When I the Totals & Filters tab under Pivot Table options both Grand Total boxes are checked. Is there a way the get both Grand Totals at the same time. Any advice would be greatly appreciated. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grand Totals for Pivot Tables
You'll only see a Grand Total for rows if there's a Column Labels field.
Then, it will show a total for each Value field, for each column field. You have multiple Value fields, and a Grand Total for rows won't show a total for those. Perhaps you could create a Total Pmt column in your source data, and add that to the pivot table. Boater wrote: I have the exact same problem "ExcelPeter218" wrote: Just to Clarify I'm Using Excel 2007 "ExcelPeter218" wrote: I have a Pivot Table based on a Table that consists of the following fields: Provider, Date, Pmt1, Pmt2, Pmt3, Pmt4 When I create the Pivot Table using the Insert-Pivot Table feature I specify Provider and Date as Row Labels and Sum of each of the Pmt fields as values. The resulting table has a Grand Total at the bottom for the columns but I cannot get a Grand Total for the rows at the right. When I the Totals & Filters tab under Pivot Table options both Grand Total boxes are checked. Is there a way the get both Grand Totals at the same time. Any advice would be greatly appreciated. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grand Totals for Pivot Tables
That fixed it thanks very much
"Debra Dalgleish" wrote: You'll only see a Grand Total for rows if there's a Column Labels field. Then, it will show a total for each Value field, for each column field. You have multiple Value fields, and a Grand Total for rows won't show a total for those. Perhaps you could create a Total Pmt column in your source data, and add that to the pivot table. Boater wrote: I have the exact same problem "ExcelPeter218" wrote: Just to Clarify I'm Using Excel 2007 "ExcelPeter218" wrote: I have a Pivot Table based on a Table that consists of the following fields: Provider, Date, Pmt1, Pmt2, Pmt3, Pmt4 When I create the Pivot Table using the Insert-Pivot Table feature I specify Provider and Date as Row Labels and Sum of each of the Pmt fields as values. The resulting table has a Grand Total at the bottom for the columns but I cannot get a Grand Total for the rows at the right. When I the Totals & Filters tab under Pivot Table options both Grand Total boxes are checked. Is there a way the get both Grand Totals at the same time. Any advice would be greatly appreciated. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Totals: Group totals different from Grand totals | Excel Discussion (Misc queries) | |||
Pivot Tables - Grand Totals | Excel Discussion (Misc queries) | |||
Need help with grand totals in pivot table | Excel Discussion (Misc queries) | |||
display grand totals on pivot chart | Charts and Charting in Excel | |||
Pivot Table Grand Totals | Excel Worksheet Functions |