Pivot table - do not display 'zero' fields

[Mel Smith]

I am trying to learn how to use Pivot tables and I cannot see how, from my dataset, not to display records with zero data. i.e I have each name but if their output is zero, I do not want to see them listed. how can I do this?

Mel

 

[RoryA]

Filter the name field for values greater than 0.

 

[Mel Smith]

Thanks, RoryA. So obvious when you see the answer!

Mel

 

[RoryA]

It usually is! Glad we could help.