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?

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?

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?

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

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

.