Pivot table to query data in a set range

  • Thread starter Thread starter adman4
  • Start date Start date
A

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?
 
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?
 
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?
 
Back
Top