Pivot Table Question

[Liz J]

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.

 

[M Kan]

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.