| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table to query data in a set range
I'm with a real estate company and we do a lot of analysis of properties in
specific price ranges. Is there a way in a pivot table to set filters by a range of data? For example, I want to look at average days on market for properties that are priced $500K to $1M? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table to query data in a set range
You can do with Auto Filter.
"adman4" wrote: I'm with a real estate company and we do a lot of analysis of properties in specific price ranges. Is there a way in a pivot table to set filters by a range of data? For example, I want to look at average days on market for properties that are priced $500K to $1M? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table to query data in a set range
I tried to apply auto filter to the data set, but when i refresh the data in
the pivot, the displayed info doesn't change. Can one apply the auto filter so that the data set does change? "Teethless mama" wrote: You can do with Auto Filter. "adman4" wrote: I'm with a real estate company and we do a lot of analysis of properties in specific price ranges. Is there a way in a pivot table to set filters by a range of data? For example, I want to look at average days on market for properties that are priced $500K to $1M? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table to query data in a set range
Well auto filter is a best way to pivot table but must save all settings
nothing to do other way. adman4 wrote: I'm with a real estate company and we do a lot of analysis of properties in specific price ranges. Is there a way in a pivot table to set filters by a range of data? For example, I want to look at average days on market for properties that are priced $500K to $1M? -- #1 Data Recovery Services Stellar Information Systems Ltd. D18, Sector-33, Infocity Phase II, Gurgaon-122001 Phone : (0124) 326 6069, 432 6700 Website : http://www.stellarinfo.co.in/ Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/201004/1 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table to query data in a set range
How does one save settings? The rows that are made filtered out are hidden
and it doesn't appear they can easily be deleted. Do you know how? "nancy0123 via OfficeKB.com" wrote: Well auto filter is a best way to pivot table but must save all settings nothing to do other way. adman4 wrote: I'm with a real estate company and we do a lot of analysis of properties in specific price ranges. Is there a way in a pivot table to set filters by a range of data? For example, I want to look at average days on market for properties that are priced $500K to $1M? -- #1 Data Recovery Services Stellar Information Systems Ltd. D18, Sector-33, Infocity Phase II, Gurgaon-122001 Phone : (0124) 326 6069, 432 6700 Website : http://www.stellarinfo.co.in/ Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/201004/1 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table - Can Data Range be on multiple worksheets? | Excel Discussion (Misc queries) | |||
| update pivot table data range | Charts and Charting in Excel | |||
| How do I set the pivot table to auto-update the data range? | Excel Discussion (Misc queries) | |||
| Pivot Table Data Field Query | Excel Worksheet Functions | |||
| Using Microsoft Query data in a pivot table. | Charts and Charting in Excel | |||
Hybrid Mode
