View Single Post
  #2   Report Post  
CarlosAntenna
 
Posts: n/a
Default

In your pivot table, right click on the field name, choose field options,
clear the check box for "Show items with no data".

Carlos

"suhair" wrote in message
...
Hi,
Can i get help!!
I have a pivot table, and in the data i have a sum of
quantity of items, i dont want to see items that there
sum is zero, (the zero is because of number of records
that there sum is zero!!!).
Can u help me to hide these items?
Thank you,
Suhair