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!

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

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