ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Grand Totals for Rows not displaying (https://www.excelbanter.com/excel-discussion-misc-queries/63187-grand-totals-rows-not-displaying.html)

Chad Richardson

Grand Totals for Rows not displaying
 
Excel 2003

I have a pivot table with the "Grand Total For Rows" and "Grand Total For
Columns" enabled. The grand total for columns show up as the last row, but
the grand total for rows does not show up as the last column???? I am pretty
adept with MS pivot tables, but can't figure out how to get them to display.

Any ideas.

Thanks in advance,

Chad



Debra Dalgleish

Grand Totals for Rows not displaying
 
Do you have fields in the column area?

Chad Richardson wrote:
Excel 2003

I have a pivot table with the "Grand Total For Rows" and "Grand Total For
Columns" enabled. The grand total for columns show up as the last row, but
the grand total for rows does not show up as the last column???? I am pretty
adept with MS pivot tables, but can't figure out how to get them to display.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


Chad Richardson

Grand Totals for Rows not displaying
 
Yep


"Debra Dalgleish" wrote in message
...
Do you have fields in the column area?

Chad Richardson wrote:
Excel 2003

I have a pivot table with the "Grand Total For Rows" and "Grand Total For
Columns" enabled. The grand total for columns show up as the last row,
but the grand total for rows does not show up as the last column???? I am
pretty adept with MS pivot tables, but can't figure out how to get them
to display.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





All times are GMT +1. The time now is 11:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com