Pivot Tables - removing empty rows

Pivot Tables - removing empty rows

Didn't find your answer?

I am turning a mass of data into a pivot table
The resultant table would be half the height and width if redundant account codes / cost centres weren't included
All ideas welcome
Stephen Burt

Replies (4)

Please login or register to join the discussion.

Routemaster image
By tom123
22nd Aug 2007 16:48

Add yes/no field
How about adding a yes/no field to the data, against the account codes that you wish to omit.

Then, in the pivot table layout, use this field to create pages. You can then select the yes or no alternatives from the drop down box, This will give the table just the codes you need.

Alternatively, filter your source data before creating the table.

Thanks (0)
avatar
By David Carter
01st Sep 2007 10:45

Filter it out
Tom's right. Filter it out before you import. If you don't want to display junk, don't bring it in in the first place.

Or you can just click on a column, then hit the ZA icon. This will shove all the zero values to the bottom of the list.

Thanks (0)
avatar
By User deleted
01st Sep 2007 18:49

David Carter,
I think I'm right also!

Thanks (0)
avatar
By User deleted
31st Aug 2007 14:52

http://www.asap-utilities.com/
Asap Utilities provide a useful add-on for Excel, recommended several times on Any Answers. One facility provided is the ability to hide rows or columns based on user criteria. In your example, I'm assuming redundant codes would have zero values attached, so you could hide all rows with zero value.

Thanks (0)