View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Manoj
 
Posts: n/a
Default Queries on Pivot table

Double click on the field name and check if there are any data items
highlighted in the "Hide Items" box in the bottom. You have an option of
suppressing the data items using this method. Click on the highlighted data
items to unhide it.

See if this works.

Manoj
India

"Hari" wrote:

Hi,

I have many page fields. I see that some of the page fields have --
(All) -- displayed in the drop-down box while 2 of the page fields have
-- (Multiple Items) -- in the drop-down box. Why such a difference?

Also one of the page fields which has -- (Multiple Items) -- is not
displaying the list of all unique entries for that column in the source
data. (This happens after I change this item to a column field and
select only some of the values and when I get bored I change this field
back to a page field).

regards,
HP
India