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.

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.