Pivot Table Question

L

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top