tags:

views:

1237

answers:

2
Q: 

Excel Pivot Tables: How can I display multiple grand total rows?

Excel Pivot Tables can display a grand total row that, by default, sum each column's data.

I would like to display multiple grand total rows that display each column's count, average, standard deviation, and standard error.

Does anyone know how to do this?

A: 

Show Multiple Grand Totals

Jim G.  2009-10-05 18:35:47
A: 

Just add the same data fields, but change the "Summarized By" under "Field Settings".

AMissico  2009-10-05 18:36:55
-1: Either you misunderstood me or I'm misunderstanding you. I'd like to display *multiple* grand total rows at the *same time*.
Jim G.  2009-10-05 18:51:47
You can add multiple fields to the Data area. When you do this, Excel moves the fields to the Column area (by default). Right-click on the field, select "Field Settings", and change the "Summarize By" value. The column "Grand Total" will go away (when the data fields are moved to the Column area), because the total is inaccurate when there are multiple fields in the data area.
AMissico  2009-10-05 22:47:57
What is described in the "Show Multiple Grand Totals" link is similar, but there is no data value (average) for each item.
AMissico  2009-10-05 22:51:30

related questions

Excel PivotTable from External Source with Query/Filter
Freeware pivot table component for Delphi?
How to generate Pivot table in ExcelSheet Programatically
Changing Excel 2000 pivot chart unit
Refresh Pivot Table with Apache POI
Set line weight for all series in Excel 2000 pivot chart
Excel Pivot Table Row Labels Not Refreshing
Embedding an Excel pivot table into C# winforms
Help needed with Dynamic Pivoting in SQL2005
Excel pivot table question - How to get subtotals for a row area field?
Speed up pivot table filtering VBA code
How to summarize date counts
Updates on PIVOTs in SQL Server 2008
Excel query table still works after deleting File DSN, how is that possible?
How to change pivot table data source in Excel?
Pivoting Concept.
Pivot Table Grand Total at the top
Has anyone used ADOMD.NET with WPF DataGrid?
Excel VBA or VSTO - How do you loop over Fields on a PivotTable?
Excel - calculating durations of time data spread across multiple rows
Programmatically exclude page items in olap pivot
Excel 2007 pivot tables - how to use calculated fields when connecting to a data cube?
How do I programmatically build ad-hoc queries quickly?
How can I refresh all the pivot tables in my excel workbook with a macro?
Options for PivotTables in Excel