Hiding Zero rows in Pivot Table
Posted by Dave D on March 28, 2001 7:38 AM
I use pivot tables on a daily basis and use calculated fields/items etc., but I am stumped on one thing. If i have say projects as a column item and staffing per month(sum of) as my data item. It shows the projects with zero staffing across the months and i wind up manualy deletin rows with zero before I can paste the result in a presentation. I have tried using IF statments to say if sum of twelve months is 0 than Yes
and I make this a page item to filte 0's. Is there an easier way????