Pivottable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Is it possible to select a range in the output of a pivot-table?

A simple example:
Name Age Town
John 5 Copenhagen
Doe 6 Vienna
Rob 10 Budapest
Deb 8 Vienna

In the pivottable I would like to select the range of persons 5 to 8 years
old. And not by selecting each year in the drop-down. Is this possible?

Any response appreciated. Also let me know if I need to clarify, thanks.
 
Do you need to do this in a pivot table? Perhaps it would be easier to
use an AutoFilter in the source data, where you could use a custom
filter to view records in that range.
 
Thanks for your quick reply.
Yes it has to be in the pivottable. I'm aware of the autofiler, but it
doesn't fully suit my purpose. The users will then have to swap between the
pivot-table and the data, which is not so convenient.
But it doesn't sound on you like there is a 'standard' function for this?
 
In Excel 2007 you could filter the row field for a range of ages. In
earlier versions that feature isn't available.

If you don't have Excel 2007, and you don't want to use the check boxes,
perhaps you could use programming to allow users to enter an age range
in cells on the worksheet, then the macro would change the pivot table.
 
OK, sounds like it's time for an upgrade then ;-)

Once again thanks very much for your quick answer.
 
Back
Top