Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default Pivot Table Grand Total - Cells Blank

I have a pivot table with one grand total column. Most of the cells in the
column are populated with a total; however, I have a few cells that do not
reflect a total even when there is data in the row. Can you anyone help me
understand why this may be happening?

Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default Pivot Table Grand Total - Cells Blank

On Jun 23, 9:56*pm, Johnnie wrote:
I have a pivot table with one grand total column. *Most of the cells in the
column are populated with a total; however, I have a few cells that do not
reflect a total even when there is data in the row. *Can you anyone help me
understand why this may be happening?

Thanks!


Try using SiSense. It imports the excel data, is free, and has much
easier pivot tables. http://www.sisense.com
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default Pivot Table Grand Total - Cells Blank

Can you give an example of a couple of row where the total shows, and a
couple where it doesn't show?

Johnnie wrote:
I have a pivot table with one grand total column. Most of the cells in the
column are populated with a total; however, I have a few cells that do not
reflect a total even when there is data in the row. Can you anyone help me
understand why this may be happening?

Thanks!



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Grand Total Tufail Excel Discussion (Misc queries) 2 January 9th 08 01:23 PM
Pivot Table (Grand Total) IF Statement[_2_] Excel Discussion (Misc queries) 1 November 19th 07 08:07 PM
Pivot Table Grand Total Stonewall Excel Discussion (Misc queries) 3 June 12th 07 12:25 AM
Sorting Pivot Table by Grand Total Meg W Excel Discussion (Misc queries) 2 April 19th 06 04:25 PM
Grand total in Pivot-Table TaiwanSwede Excel Worksheet Functions 0 January 10th 06 04:03 AM


All times are GMT +1. The time now is 08:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"