Eliminating empty rows in Pivot table

D

DogEatDog World

Problem is that you can't simply filter out some data field because in some
row fields they have values and at some they don't. So what I essentialy need
is for those rows to exist when they contain data and to be erased when not
containing data.I hope that it+s possible in excel 2007
 
A

Ashish Mathur

Hi,

Click on the immediate cell to the right of the Grant Total (for columns)
cell, and press Auto Filter. This will get the auto filter drop down on the
Grand Total column. Now filter out the Blanks.

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
D

DogEatDog World

Ashish Mathur said:
Hi,

Click on the immediate cell to the right of the Grant Total (for columns)
cell, and press Auto Filter. This will get the auto filter drop down on the
Grand Total column. Now filter out the Blanks.

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com


THANKS A LOT MR MATHUR. IT WORKS
Click to expand...
 

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

Pivot using 250,000 rows of data in Excel? 1
Apply Filter to source of Pivot Table 2
Pivot table Help Excel 2007 1
Pre-configuring Pivot table "views" 4
Pivot Table Calculations 2
OLAP Pivot table - How to show items with no data ? 1
Pivot Excel 2007 2
Unable to Group in Pivot Table 1

Top