Pivot Table Question

[aka_krakur]

I have a Pivot table that has the months going across the top row,
and there is a part/lot # combination that it is counting the # of Lots;
Then I applied a Top 10 filter on the Parts by Count of Lots.
However, there are multiple months that there are zero...is there a way to get the pivot table to hide these?
it's messing up my chart by placing null/blank values on the chart when all I want to chart is the months that actually are found in the top 10 from my pivot.

 

[share_knowledge]

I have the same issue with my pivot table but not sure how to solve this. Could you please let me know once you found out a way to hide these zero rows? thanks!

 

[share_knowledge]

http://www.mrexcel.com/board2/viewtopic.php?t=288988

tried this. Boller just helped me out and it just worked out the way we wanted (work for me at least). good luck!