Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Sub-Totals | Excel Worksheet Functions | |||
Totals in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table Row Totals | Excel Discussion (Misc queries) | |||
Pivot Table Chart - With Pivot Table Totals | Charts and Charting in Excel | |||
Pivot Table - Sub totals | Excel Discussion (Misc queries) |