Pivot table totals?

G

Guest

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
 
D

Debra Dalgleish

You can filter the row fields in Excel 2007, but not in earlier versions.
In earlier versions, you can uncheck the numbers in the House Number
field dropdown list.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Column Totals - XL2003 5
Referencing a pivot tables Grand Totals Column 1
Pivot Table - move Totals column 1
Pivot table problem 4
Value filter missing in pivot table 3
Pivot Table totals 3
Pivot Table 1
Count of Non-Zero pivot table entries 1

Top