View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Neil Neil is offline
external usenet poster
 
Posts: 173
Default Pivot table totals?

Hi

I have a pivot table with road number, house number and for my data against
this a count of occurrences. I can then select either the different road
names to look at a specific address. Is there a way i can select a a number
from the totals columns ie 4 or above to just show the address with the 4 or
above ocurrences?
I tried to a auto filter above the column where i can select the number but
it will only show other data in the line so misses the adderss info i need.

Many thanks