Pivot table display

Is there a way to hide categories with 0/nothing in pivot table

For Example: (Pivot Table)

Vendor Name Data Total (Drop Down Bar)
KRAFT/AURORA-DRY
Short 97
Damaged <-----hide
Quality Issue <-----hide
Mis-ship <-----hide
Others 432
Total Variance 555
TYSON FOODS INC.
Short 476
Damaged <-----hide
Quality Issue 2
Mis-ship <-----hide
Others <-----hide
Total Variance 478
...

You mean?

http://www.techonthenet.com/excel/pi...ide_blanks.php

Can you attach an actual pivot table example, so that I can see how you constructed it and from what....

You can change up confidential information.

I am not sure that this is possible here (maybe with VBA???).

One of the items (Others) have all blanks, and there has to be at least one displaying...

The others are like filtering with Autofilter.. by process of elimination, you end up hiding fields that shouldn't be because you filtered another field first, etc...

Have you considered displaying it with column headers instead?

Just drag the DATA button to the right.. and it should change format. Is that more usable?

Originally Posted by ybu1106

No, that doesn't work. My boss just doesn't like to see blanks and zeros. He prefers only seeing what is relavant.

Perhaps someone can do it with VBA for you ... or google something like Hide Rows with blank cells" to find some code.

Originally Posted by ybu1106

What about formatting cells? from the 1st dummy book. (Bolding/coloring certain field/category)

Select column and go to Format|Conditional Formatting and select Formula Is from drop down menu... enter formula: =SEARCH("Total",B1) and click Format and choose from the tabs.

Remove the current conditional formula.

Then select both columns and re-invoke CF and use formula:

=SEARCH("Total",$B1)