Wednesday, 7 August 2013

Removing blank Excel Pivot Table entries

Removing blank Excel Pivot Table entries

I have a pivot table based on PowerPivot with multiple levels in the Rows
section. Quite a few of the elements are blank. Is there a way to suppress
the blank rows?
My Pivot Table looks like this at the moment.
Product1
Release 1
Iteration 1
Iteration 2
Release 2
(blank)
Product2
(blank)
Product3
Release 1
Iteration 1
Sprint 1
(blank)
(blank)
(blank)
That's just an example. I've tried to set filters for each level not to
display blanks but if I filter each level to hide blank fields the pivot
table doesn't have any items in it. It seems that Excel ends up filtering
each level out that has ANY blank values.
Not sure if I made sense or provided enough information for
troubleshooting. I'm pretty much brain dead at the moment so I apologize.
Please let me know if it doesn't make sense or if I can provide any
additional information to clarify what I'm trying to do and encountering.
Thanks.

No comments:

Post a Comment