Pivot table to query data in a set range

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?
 
A

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?
 
A

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table missing customers 1
Adding to an existing Pivot Table 7
Pivot Table Ranges 8
date filter in a pivot table 1
pivot table data 2
Pivot Table Refresh not working properly 1
pivot table rolling 12 month filter? 1
Pivot Table counting a range 1

Top