View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pepperds pepperds is offline
external usenet poster
 
Posts: 5
Default Limiting Results in a Pivot Table

Hi,

have been looking in the online help and cannot find an answer to what I'm
assuming should be a simple job;

I have a pivot table showing countries A-Z in the Page Section, with Minutes
(I work for a Telecoms co) in the Data Section. The Minute values range from
3 through 3 million. How can I limit the data to show, for example, only
those Conutries that have more than 1 million minutes, or between 1 million &
2 million

Many thanks in advance