Pivot table to query data in a set range

[adman4]

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?

 

[Teethless mama]

You can do with Auto Filter.

 

[adman4]

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?

 

[nancy0123 via OfficeKB.com]

Well auto filter is a best way to pivot table but must save all settings
nothing to do other way.

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.aspx/ms-excel/201004/1

 

[adman4]

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?