Removing Data from Pivot with zero values

Hi,

I have a worksheet with columns A to E which hold the following data:-

Week No, Budget Code, Budget Description, Name and Hours

However, as you can see in the attached spreadsheet there is not always a value in the hours field.

What I want to achieve is to automatically exclude any of the rows of data in the Pivot table that includes zero in the hours field (such as the rows highlighted in yellow) and also not to show if/when the pivot table is refreshed.

Any help would be gratefully appreciated


Many thanks in advance

Regards


Rob

N.B. Excel version 2003

If you keep the Hours as a Row Field you can just deselect 0 as a value to list. If you remove the Hours from being a Row Field it may be best to add a field to your source that flags if hours >=0 .. True/False kind of thing and use that Field as a Page Field set to TRUE ... thereby excluding 0 hour records.

cant you just right click hours select field hide 0

DonkeyOte

many thanks for your assistance in this matter, your suggestions worked as required.

Regards


Rob