View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Liz J Liz J is offline
external usenet poster
 
Posts: 1
Default 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.