Hiding Pivot field if Subtotal = 0

[Kobayashi]

Does anybody know if this can be done?

I currently have a Pivot table that uses a Sum of a particular field as it's data source. However, if the subtotals, once the pivots are created is zero I would like to hide the particular items that have a zero subtotal.

Many thanks,

Adrian

[Kobayashi]

Getting desperate. Would really appreciate some help...