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

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