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.

Jan wrote:
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.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html