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
|