Pivot Table Question
 

Hi.

When I create a pivot table, the last row before the "Grand Total" row is
titled "(blank)." Even if there are no blank items within the pivot table,
Excel still produces a "(blank)" row in the pivot table. Is there any way to
getting rid of or automatically defaulting Excel to not produce the "(blank)"
row? (Without, of course, hiding a column.)

Thank you.

Pivot Table Question
 

Have you checked your data range to ensure it doesn't extend beyond your
populated fields. Pivot tables don't default to showing BLANK if there
aren't any.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Liz J" wrote:

Hi.

When I create a pivot table, the last row before the "Grand Total" row is
titled "(blank)." Even if there are no blank items within the pivot table,
Excel still produces a "(blank)" row in the pivot table. Is there any way to
getting rid of or automatically defaulting Excel to not produce the "(blank)"
row? (Without, of course, hiding a column.)

Thank you.