Excel Pivot Table row heading (blank) with no data in it


S

SeanF74

I have a pivot table where the last row before the grand total has a (blank)
across all of the row label and there is no data across any of the columns
(e.g., the total of the row is 0). Is there any way to remove this blank row
from this table?

Note: My data range for the pivot table (Raw!$A$1:$AR$65536) is larger than
the amount of data I inputted to create the table (Raw!$A$1:$AR$4293). If I
change the data source to the size of the data I inputted, it removes the
(blank) line. However, I need to change the data often, and the number of
rows in the data will change and I would rather change the data source range
every time because I could forget.

Thanks,

Sean
 
Ad

Advertisements

S

SeanF74

Figured it out. All i have to do in Excel 2007 is right click the field -->
filter --> hide selected items.
 
Ad

Advertisements

J

Jim Thomlinson

Doing that will bloat the file as it is storing a whole lot of of nothing.
Take a look at the dynamic named ranges...
 

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

Top