Hi,

Using Windows 2000 and Excel 2000

I have created a pivot table which correctly shows the data returned,
however, I don't want to show entries where the total (sum of data) is equal
to 0 (a zero). I've tried to turn on Filter but this option isn't
available.

Any pointers most welcome.

Rob